DSXchange

All, I'm getting following error while trying to view fix length sequential (UNIX flat) file in datastage. Error: Bad record delimiter after fixed-length record: expected "\n", got "\x00" I have set following properties for fix length file... Record Level Record Delimiter = UNIX ...

Well, I deleted unicode from extended column in column tab and now i'm not getting this error. I don't understand what is unicode and when to use it?

Is there any issue with datastage to convert timestamp field? I have SQL server table as source and one of the field in that table is timestamp. When I view the data using Dynamic RDBMS stage I see extra 3 zero's added at the end. For e.g. SQL server shows timestamp field as 2003-09-30 14:30:20.497,...

8th field is line_2_addr varchar(50).

I'm getting following error when I try to load data from one sql server table to another sql server table. Field 7 is line_1_addr varchar(50). Any ideas why i'm getting this error? Thanks in advance. Error: Field type must be string in order to call setOutputFieldAsString() for field '7' in output d...

Thanks Ray.
I work on other ETL tool, which does this on the fly. I can reuse same job for different sources and targets by just specifying different patameters.

How do I export data from DB2 (MAINFRAME) table into flat file from command line without creating datastage job? Source and target will be specified on command line to dsjob. I'm expecting datastage should pick up table layout (metadata) from source parameter. Is it possible? Is there any other quic...