DSXchange

In the table definition the Display Width is the actual width used in the file. This can be accessed as the Field Width property in extended column properties (Edit Row from the Columns grid). ... Hi Ray, Thanks for the suggestion. I was not aware of that. However, my problem got resolved when i cr...

Hi, I have a .dat file which i need to load into a table. The file is fixed-width with no delimiters for fields. The file has 10 different columns and each of the columns i read them as char(n). The total length of the fixed data is 89 chars. I am not sure if UNIX newline is the record delimiter? Th...

Hi, I have a parallel job that uses a ODBC stage as input for a netezza table. There are joins with other tables and the records ranges from hundreds to millions. After transformations and lookups, are loaded into the target table in netezza. The job validates correctly, however, when i run the job ...