Search found 60 matches
- Fri Mar 09, 2018 8:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC error "String index out of range: -1"
- Replies: 0
- Views: 2048
ODBC error "String index out of range: -1"
For ODBC source connection in my datastage job I'm getting error as "String index out of range: -1" when i try to import the job to different server. I see that in Generated OSH script the below line. Not sure is it because of that the issue is occuring. "#############################...
- Mon Dec 18, 2017 3:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with left justified column with spaces in fixed length
- Replies: 3
- Views: 2994
Issue with left justified column with spaces in fixed length
Hi Team, I want my out put file to look like below: 20 11111 xxxxxx 20 11111 yyyyy datatype is, col1 char(1), col2 char(2), col3 char(9),col3 char(6) when im running my datastage job im always getting extra space after every value like below: 2 0 11111 xxxxxx for the 1st char im always getting extra...
- Mon Mar 16, 2015 8:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: column to row
- Replies: 3
- Views: 2574
- Mon Mar 16, 2015 3:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: column to row
- Replies: 3
- Views: 2574
column to row
I/P:
ID,COLNAM,COLVAL
1,A,RAM
1,B,SHYAM
1,A,RAHIM
1,B,ROBERT
2,A,JOHN
2,B,JOHAN
O/P:
ID,A,B
1,RAM,SHYAM
1,RAHIM,ROBERT
2,JOHN,JOHAN
need help in designing this job.
ID,COLNAM,COLVAL
1,A,RAM
1,B,SHYAM
1,A,RAHIM
1,B,ROBERT
2,A,JOHN
2,B,JOHAN
O/P:
ID,A,B
1,RAM,SHYAM
1,RAHIM,ROBERT
2,JOHN,JOHAN
need help in designing this job.
- Tue Apr 08, 2014 2:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: horizontal pivoting using transformer
- Replies: 14
- Views: 13108
- Mon Apr 07, 2014 4:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: horizontal pivoting using transformer
- Replies: 14
- Views: 13108
- Mon Apr 07, 2014 4:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: horizontal pivoting using transformer
- Replies: 14
- Views: 13108
horizontal pivoting using transformer
Hi All, Needed a logic in transformer for the below scenario. i shouldn't use pivot stage. and needed in datastage and not using unix. I/P data: Account_numb Name Total 123 ABCDEF 123456789 345 GHIJKLMN 987654321 O/P data: Account_numb Name Total 123 AB 123 123 CD 456 123 EF 789 345 GH 987 345 IJ 65...
- Mon Apr 07, 2014 4:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: horizontal pivoting using transformer
- Replies: 3
- Views: 2005
horizontal pivoting using transformer
Hi All, Needed a logic in transformer for the below scenario. i shouldn't use pivot stage. and needed in datastage and not using unix. I/P data: Account_numb Name Total 123 ABCDEF 123456789 345 GHIJKLMN 987654321 O/P data: Account_numb Name Total 123 AB 123 123 CD 456 123 EF 789 345 GH 987 345 IJ 65...
- Thu Nov 28, 2013 7:05 am
- Forum: General
- Topic: Abort Sequencer only after jobs finish in case of failure
- Replies: 2
- Views: 2240
Abort Sequencer only after jobs finish in case of failure
Hi All, Job1 Activity -> In job Triggers Custom-(Conditional) is selected for both Routine Activity1 and Terminator Activity1 to check for any ORA-ERROR Job2 Activity -> In job Triggers Custom-(Conditional) is selected for both Routine Activity2 and Terminator Activity2 to check for any ORA-ERROR Jo...
- Thu Nov 28, 2013 6:44 am
- Forum: General
- Topic: How to abort sequencer only when all jobs finish during fail
- Replies: 1
- Views: 1687
How to abort sequencer only when all jobs finish during fail
Hi All, My Sequencer looks like: Job1 Activity -> In job Triggers Custom-(Conditional) is selected for both Routine Activity1 and Terminator Activity1 to check for any ORA-ERROR Job2 Activity -> In job Triggers Custom-(Conditional) is selected for both Routine Activity2 and Terminator Activity2 to c...
- Fri Sep 06, 2013 1:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to fetch integer part from decimal data
- Replies: 10
- Views: 5641
- Thu Sep 05, 2013 8:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to fetch integer part from decimal data
- Replies: 10
- Views: 5641
- Thu Sep 05, 2013 7:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to fetch integer part from decimal data
- Replies: 10
- Views: 5641
Need to fetch integer part from decimal data
my source data contains value as "1234.56" which is of decimal(17,2) datatype. In my target table: i want only the integer part of above value appended with zeroes at the starting for varchar2(16) datatype. in target value needed is "0000000000001234" Please let me know what func...
- Thu Jun 20, 2013 6:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue in using @INROW function
- Replies: 9
- Views: 5184
- Fri Jun 14, 2013 5:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue in using @INROW function
- Replies: 9
- Views: 5184