Search found 264 matches
- Mon Aug 31, 2020 2:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: File Processing
- Replies: 1
- Views: 14279
File Processing
Hi All, Kindly advice to process the below file : 001234 ABC ABCD-PEFF 07-24-2020 14:33:03 07-24-2020 14:33:03 AB1234 A012 002 AB POINT AAAA 003 AB APPL ID RED 004 AB TYPE 005 AB PART ID 01234 006 AB PART DET ID 020 AB ALPHA DESC NAME ABC 023 AB CONSOL NO 024 AB ALT KEY 01234 000 AB STOP 004567 ABC ...
- Tue Feb 12, 2019 5:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TD Connector:After SQL
- Replies: 2
- Views: 3345
- Fri Feb 08, 2019 3:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TD Connector:After SQL
- Replies: 2
- Views: 3345
TD Connector:After SQL
Hi All, Kindly clarify the below on Teradata Connector: I have a job that writes to TD . First step is to insert the data to temp table and in after sql we are reading the data from temp table and insert into main table For instance if the After SQL statement fails in the middle of the execution , f...
- Mon Dec 04, 2017 6:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to remove the empty tags in Hierarchical Stage
- Replies: 5
- Views: 4637
- Fri Dec 01, 2017 1:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to remove the empty tags in Hierarchical Stage
- Replies: 5
- Views: 4637
How to remove the empty tags in Hierarchical Stage
Hi All, I have to remove the empty tags in XML. My parent tag in the xsd has the min occurs =0 and child tag associated with the parent has min occurs =1. If I don' t receive parent value then i should not send the child tag . Since the min occurs for the child tag =1 , the tag is getting populated....
- Mon Oct 26, 2015 11:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert rows into mysql using java client or java transformer
- Replies: 6
- Views: 4416
- Mon Oct 26, 2015 11:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert rows into mysql using java client or java transformer
- Replies: 6
- Views: 4416
Re: Insert rows into mysql using java client or java trasnfo
Hi All,
Any help is appreciated.
Please Advise.
Thanks,
Kumar66
Any help is appreciated.
Please Advise.
Thanks,
Kumar66
- Sun Oct 25, 2015 7:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert rows into mysql using java client or java transformer
- Replies: 6
- Views: 4416
Insert rows into mysql using java client or java transformer
Hi All, I have a requirement where I need to insert records into MySQL table using SSL connection. Currently we are using JDBC connector stage to load into MySQL table. I am trying out options to use java transformer or java client stage for target. Since I am inexperienced in java, I need help here...
- Fri Nov 14, 2014 1:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error in building output schema
- Replies: 3
- Views: 4543
Re: Fatal Error in building output schema
Hi All,
The issue has been resolved. I added single space i.e ' ' for the null values rather ''.
It worked.
Thanks.
The issue has been resolved. I added single space i.e ' ' for the null values rather ''.
It worked.
Thanks.
- Fri Nov 14, 2014 11:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error in building output schema
- Replies: 3
- Views: 4543
Re: Fatal Error in building output schema
hi Chulett,
Since it is RCP job, I am confused to proceed
further.
Please advice
Since it is RCP job, I am confused to proceed
further.
Please advice
- Fri Nov 14, 2014 10:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error in building output schema
- Replies: 3
- Views: 4543
Fatal Error in building output schema
Hi All, I have a RCP job OracleConnector ----> XFRM----->FILE when the query is excuted I am getting the follwoing error: Error creating schema ( record( PROJECT_KEY:nullable string[max=50]; PN:nullable string[max=100]; MID:nullable string[max=32]; LN:nullable string[max=30]; FN:nullable string[max=...
- Wed Nov 05, 2014 10:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace String
- Replies: 7
- Views: 5533
- Wed Nov 05, 2014 9:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace String
- Replies: 7
- Views: 5533
Replace String
Hi All,
I have a requirement where the last field in a row needs to contain unique value
for e.g.
input
aaa,rrrr,1|2|1|3
bbb,eee,1|2|2|3
output:
aaa,rrrr,1|2|3
bbb,eee,1|2|3
Please advise.
Thanks.
I have a requirement where the last field in a row needs to contain unique value
for e.g.
input
aaa,rrrr,1|2|1|3
bbb,eee,1|2|2|3
output:
aaa,rrrr,1|2|3
bbb,eee,1|2|3
Please advise.
Thanks.
- Wed Aug 13, 2014 9:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SMP to Grid
- Replies: 2
- Views: 3009
SMP to Grid
Hi All,
We are in the process of migrating the datastage jobs from SMP to Grid environemnt.
Any special considerations needs to be taken care in the migration.
Kindly assist me.
Thanks,
Kuamr66
We are in the process of migrating the datastage jobs from SMP to Grid environemnt.
Any special considerations needs to be taken care in the migration.
Kindly assist me.
Thanks,
Kuamr66
- Tue May 06, 2014 5:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem in running Multi Instance
- Replies: 4
- Views: 3489