DSXchange

Hi

Though this issue is discussed in the forum, I tried all the options.

By running the job I'm getting the WARNING message, but the data is loading to table without any problem.

Any of you have any idea to get rid of the WARNING message.

Thanks,
Siva

Verify the data in new file and check any extra spaces or characters are there.

What stage are you using? DB2 API or Enterprise?

How many jobs are you calling in the sequence?

Shiva

Check database connection details(userid, password) details in your job/seq.

Try by removing the parameter set from the job and add it again..compile and run..

You can write a script and call it in before/after routine

Is the columns in both data sets are in same order with same data types?

Is the columns in both data sets are in same order with same data types?

Right function usually trims the fields. Try this out.
Create a vaiable with logic something like this.

If the lenght(Column)=7 then '00':Column else....

use same logic for other lengths as well

How frequently the length of column is changing? I mean check distinct column length.

You can call the script using ExecSHSilent. Then the password will not appear in log.

Please check any locks are there on the job..

Place your file in Datastage server. Login to Datastage manager and goto Import ---> Table definitions-->Sequential file. Select the filename from directory where you placed that file and import. dssiva [quote="parameswar"]Hi, I have to import column definition from csv file. File structur...

Hi

all


iam new to datastage any one give some differences between datastage 6.x version datastage 7.x version

shiva