Search results for query: *

Hi, I am attempting a fast export of a decimal(18,0) field to a fixed file format MVS file. So, I want to put the field into character(18). This file will not be reloaded directly into teradata until other processing occurs. if I select field from table the results is a mess. if I select...

We are scheduled to move to V2R5 in a week on our development box. Today I got an email about needing to be on a different ODBC driver version for queryman, yesterday, I got another email on more reserved words that weren't reserved before. I tried looking on the teradata website for a list of...

Hi, I have a table with data in a character field, that I think should be able to be stored in a date field. So, I created a copy of the table, changed the column from character to date and am attempting to cast and insert all rows from the one table into the other table. However, I keep...

I realize that doing this iterative looping is probably very bad - the performance will be horrible. However, the business requirement is to check the results of the macro code against the results from another query. Therefore, I have run the macro as described in order to meet the purpose of...

Thanks for your response. However, even though the procedure can operate on more than one row, according to documentation it CAN NOT return more than one row which is what I need.

Hi, I have a macro that is passed in a key field, and returns multiple rows. I need to be able to run this macro in a loop with input provided dynamically (from a table). I thought about using a stored procedure, but according to documentation a stored procedure can only return one row. I...