DSXchange

Can we export multiple jobs to same "dsx" file from command line using dsexport

Can somebody help in syntax?

Did you try to use "DOS line delimiter option" in the sequential file stage

you can use sequential file stage before transformer reading "dev/null" file.

This error comes when you have limitation on file size creation. Can you check with Unix admin what is file size limit for user used to run this job [quote="somu_june"]Hi, Iam having a job which reads data from three source tables using DB2 API stage and I have join stage and I am joinning...

Do you have entery for APT_ORCHHOME in dsenv file?

I am thnking it might be missing or got incorrect PXEngine directory

Somestime, if transformation are more complex who will get this kind of error.
Here the Guidelines.

Avoid Handling Null a lot.
and convertion. Try to add one by one until you start getting this.

I would suggest many modif's to avoid these kind of problem

yes, nested function is not compatible with MODIFY stage.

Depending upon how many transformation you do and volume of the data. I would choose either of Modify vs Transformer.

From my experience I recommend Modify.

I double [] will work. If it data type "DATE", then there is no "DATE" of length 8 and "DATE" of length 10. "DATE" is Date, there is no significance for length. My assumption you are using two field of one with char(8) other wth char(10). Then you must make sa...

Which change mode you used. Depending change mode, change rest of option. Then you should able avoid this warning. [quote="ShilpaBharadwaj"]Dear All, I am facing the following warning in Change Capture stage in a parallel job - Change_Capture: When checking operator: Defaulting "TYPE_...

I agree with kcbland. Best solution tune your SQL. Or else dump the each table data into different datasets. Then perform joins in datastage. Thats how helped us a lot [quote="sravanthi"]hi, I'm using db2 udb api stage for selecting columns from a table. The time taken is too high.the job ...

Usually you get this error when you use EE stage as input and ouput in same job. If that is case split into two jobs. [quote="Nageshsunkoji"]Hi All, I am facing the following warning in DB2 EE stage db2HEW_CHANL_USAGE_SUMMins: The environment variable DB2INSTANCE is currently set to `db2in...

Hi Divya, Special character loaded could be Empty strings. If that is case When you use API stage it automatically append space in the space for character field. If it is EE stage that is not case. Explicitly add spaces in end. [quote="srividya"]Hi This is in regards to the DB2 EE Stage. W...

[quote="ray.wurlod"]Not every ten digit number is an integer.
The largest (four byte (32 bit)) signed twos-complement integer is 2147483647; the largest unsigned is 4294967295.[/quote]

yes you are right. If there is data coming wiht 3123456789, then obviously int32 will not accept.

vijay

Eventhough it is binding error, if read till the end of sentence, you will range limitation error. Because in the PX I orbserved that if have input 10 digit integer data type will not accept. You have declare as Bigint.

Try with int64_from_decimal, and declare you out data type as bigint instead of integer.

Vijay