DSXchange

As I expected.

As always - Thanks Ray for your prompt responce.

Appreciate that.

Hi, Don't know it can be done. Have not seen anywhere. I want to know if there is any way I can supress all warning and informational messages from datastage director? I want to get the Fatal warnings, but not the green and yellow ones. Also, need to know whether supressing logs adds any performance...

Hi Folks, I have a sequential file stage which reads the table definition from schema files. It is working nice and pretty, but only once it can not read the record when a nullable field is at the last of the fields. Here is a small example - Say for the schema file is like below: record {final_deli...

Wow....
Thank you Chulett, for this information!
Now my job is working perfectly...
I have one generic physical job which will extract data from over 50 tables, using column export and field functions!
Kudos to you!

Senthil,
Try Complex File Stage. Datastage supports EBCDIC and Fixed length file formats. Explore and you will find EBCDIC option in dropdown.

I have tried that approach. It shows the warning. Rows are not delimited.Contains long values. Your help is appreciated. Vino, I believe you have given an example of your file structure in your first post. There, you have shown that the files are delimeted (separated) by comma. Please check whether...

I am not a premium user. Can you please share the solution with everyone including non premium user. No. 100% of revenue from premium memberships is devoted to meeting the hosting and bandwidth costs of DSXchange. The company behind it is no Microsoft. DSXchange does not make money. It is an all-vo...

Hi Vino, Take a Sequential file stage. Open the stage, add columns in Columns tab, set the file name in Properties tab. Check the options and set those which you like. Go to Format tab. Final Delimeter is end. In Field Defaults, check whether the Delimeter is set to Comma, Quote will be Double in yo...

Another way is to make a left outer join on both the files keeping new recordset on the left link. It will give you matched record as well the new records. Add a filter to pass only those records where join column value is null. It will give only new records. Populate these values in sq file. Thanks...