Search found 103 matches
- Mon Sep 25, 2017 3:20 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup
- Replies: 3
- Views: 14959
Lookup
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...
- Mon Sep 25, 2017 11:58 am
- Forum: General
- Topic: NLS setting
- Replies: 1
- Views: 2242
NLS setting
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...
- Wed Jun 14, 2017 3:25 pm
- Forum: General
- Topic: JDBC Connector
- Replies: 1
- Views: 3061
JDBC Connector
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...
- Thu Feb 16, 2017 10:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: .ds.being_deleted
- Replies: 2
- Views: 3316
- Mon Feb 06, 2017 12:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: .ds.being_deleted
- Replies: 2
- Views: 3316
.ds.being_deleted
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...
- Wed Jun 29, 2016 6:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EBCIDIC to ASCII Conversion
- Replies: 5
- Views: 5041
- Wed Jun 29, 2016 5:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EBCIDIC to ASCII Conversion
- Replies: 5
- Views: 5041
- Wed Jun 29, 2016 2:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EBCIDIC to ASCII Conversion
- Replies: 5
- Views: 5041
EBCIDIC to ASCII Conversion
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...
- Tue Jun 28, 2016 12:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sort Stage Error
- Replies: 3
- Views: 6147
- Tue Jun 28, 2016 10:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sort Stage Error
- Replies: 3
- Views: 6147
Sort Stage Error
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...
- Fri Jan 23, 2015 4:43 am
- Forum: General
- Topic: Xmeta versus Universe
- Replies: 5
- Views: 3991
- Thu Jan 22, 2015 2:47 am
- Forum: General
- Topic: Xmeta versus Universe
- Replies: 5
- Views: 3991
Xmeta versus Universe
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 ...
@RECORD
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...
- Mon Apr 07, 2014 4:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: horizontal pivoting using transformer
- Replies: 14
- Views: 13105
Re: horizontal pivoting using transformer
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.
You could use @ITERATION <= 3 as looping condition.
Thanks
Poovlaingam.
- Thu Feb 20, 2014 8:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: dsrecord command
- Replies: 2
- Views: 3506