DSXchange

Hi, In server job I would like to understand the difference between doing the lookup using colon or bind variable and doing without using colon or bind variables. Job1: Reference stage: Oracle Connector Reference sql: Select ABC, DEF FROM XYZ; Using ABC as Key column in the Oracle Key in Oracle Conn...

Hi, I have a datastage 7.5.2 version running in unix box. I need to undestand what is the default NLS setting at project level for a particular project. NLS button is disabled for me in General tab and in the Projects tab in Administrator. I dont see NLS tab in Stage level or in Job level properties...

Hello All, Could any of you advise me why we have JDBC connector stage though we have native stages for any data base and we have ODBC connector for any database for which we dont have native stage with us? We have it because not all database vendors provide ODBC software drivers. Is my understandin...

Thank you for the reply.
I'm not able to understand why this is not happening for immediate re-run but for the second re-run I'm receiving this warning message. First re-run is working fine with no issues.

Hi, I had my job failed due to resource issues in the server. After sometime i re-ran the same job and it ran fine. But when I run second time after the abend job failed with error message "When deleting data set XXX.ds, previous delete attempt not complete; removing XXX.ds.being_deleted in ord...

I'm getting ! characater in output now . I used "Unicode" in column property and used IBM037. Thanks all :D

Its a plain text file. No packed decimal in it. I put a server job , and read as binary data type and used ASCII function in the transformer stage and it is working fine. I can see the ! symbol in the output file. But don't know how to get this in parallel job.

Hi, I'm using Character Set as "EBCIDIC" in seq file stage, nls as UTF-8. It is reading the ! in mainframe ebcidic file as ] character. I checked in below site that datastage import/export operator converts ! as ]. https://www.ibm.com/support/knowledgecenter/SSZJPZ_8.7.0/com.ibm.swg.im.iis...

This is the only server job having sort stage in it in the project. All other jobs are parallel jobs. But I created a new server job with a sort stage and it is running fine. This problem is not occurring at everytime. Sometime running fine but sometime not.

Hi, I'm getting the error "Error in retrieving stage property values DSTAGE-SORT-0041`:`Directory already existing" during run time. This is happening intermittently. I can understand some problem in doing the sorting but not able to guess the root cause. Kindly help me in getting the root...

Thank you so much Ray and Craig.

Regards,
Poovalingam.

Hi, I found one sql to query DS_JOBOBJECTS in Universe to get the list of jobs using the column name with pattern XXX. I think after 8 version we do have Xmeta database contains all meta information. Does it mean datastage maintains 2 meta data repository, one in Universe and another in Xmeta after ...

Hi, I have a requirement to get the list of jobs using a particular column. I got some results using @RECORD field in DS_JOBOBJECTS tables. I got the query from dsxchange only. I have a general question in this. Does DS_JOBOBJECTS RECORD will have all the column details of all the stages of server a...

You could try looping option in transformer stage to convert every single row to multiple rows based on our requirement.

You could use @ITERATION <= 3 as looping condition.

Thanks
Poovlaingam.

Thanks Ray..

Cheers,
Poovalingam.