Search found 134 matches
- Fri Mar 08, 2019 5:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Put quotes around fields in sequential file only with commas
- Replies: 2
- Views: 2955
Put quotes around fields in sequential file only with commas
Hi All, I am having trouble putting double quotes around a field when writing to a sequential file when the field contains a comma. The file itself is a CSV. So if the field does not contain a comma within it, it shouldn't be enclosed within double quotes, but when the field does contain a comma, it...
- Wed Jan 17, 2018 8:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: 0/0/0000 date in Sybase ASE
- Replies: 3
- Views: 3227
- Tue Jan 16, 2018 9:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: 0/0/0000 date in Sybase ASE
- Replies: 3
- Views: 3227
0/0/0000 date in Sybase ASE
Hello all, I am having trouble with extracting out a record in the Sybase ASE database with a date format of "0/0/0000". When the record is extracting or viewed inside the stage, it comes out as ";877" which is obviously not a valid date format. The job format I have is just taki...
- Tue Sep 12, 2017 2:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unicode with RCP?
- Replies: 11
- Views: 12772
- Mon Sep 11, 2017 12:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unicode with RCP?
- Replies: 11
- Views: 12772
It is failing because on of the target columns is VARCHAR(20) and one record is 21 length (it is not 21 in the source). When the data is extracted out of Sybase, it add extra bytes to the data for special characters (it hold telephone data). So the job fails because it cannot insert a record that is...
- Mon Sep 11, 2017 11:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unicode with RCP?
- Replies: 11
- Views: 12772
Ok. So if my job is:
There is no way to apply Unicode unless I add a Modify stage? And that is with RCP?
Code: Select all
Sybase stage --> Oracle stage
- Mon Sep 11, 2017 10:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unicode with RCP?
- Replies: 11
- Views: 12772
I do not use schema files to specify the table definition. My job is a very generic job. It takes data from Sybase to Oracle - a one to one move. The Select statement is generated by a routine by gathering the column names from the Sybase system table. This is done so we can load many tables using o...
- Mon Sep 11, 2017 8:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unicode with RCP?
- Replies: 11
- Views: 12772
Unicode with RCP?
Hi all,
Is there a way to use Unicode with RCP?
Thanks in advance.
Is there a way to use Unicode with RCP?
Thanks in advance.
- Fri Aug 26, 2016 11:58 am
- Forum: General
- Topic: Potential Issue with DSJS.RUNWARN in Sequence Job
- Replies: 9
- Views: 6524
- Fri Aug 26, 2016 8:58 am
- Forum: General
- Topic: Potential Issue with DSJS.RUNWARN in Sequence Job
- Replies: 9
- Views: 6524
Ah ok. So you are saying by putting the below just in the trigger, no matter what, it is always true?
I will test out your suggestion.
Thanks.
Code: Select all
DSJS.RUNWARN or DSJS.RUNOK
Thanks.
- Fri Aug 26, 2016 7:40 am
- Forum: General
- Topic: Potential Issue with DSJS.RUNWARN in Sequence Job
- Replies: 9
- Views: 6524
Thanks. If you are saying the RUNWARN has to succeed in order for it to move forward, then something else must be at play. My current trigger for the 'success' link was: DSJS.RUNWARN or DSJS.RUNOK And for my 'failed' link was just the Expression Type 'Failed' option. So then my question still remain...
- Thu Aug 25, 2016 12:35 pm
- Forum: General
- Topic: Potential Issue with DSJS.RUNWARN in Sequence Job
- Replies: 9
- Views: 6524
Thanks for the quick reply chulett. I am not a premium member, so I cannot see your entire answer. However, I am thinking you are confirming my beliefs that DSJS.RUNWARN can allow the sequence to continue even if the job is aborted when the job has warnings. I would think the safest route with have ...
- Thu Aug 25, 2016 11:02 am
- Forum: General
- Topic: Potential Issue with DSJS.RUNWARN in Sequence Job
- Replies: 9
- Views: 6524
Potential Issue with DSJS.RUNWARN in Sequence Job
Hi all, I have a sequence job that contains say 5 parallel jobs. In the fourth parallel job trigger, I have to output links. One link is for a "successful" run, and the other link is for a "failed" run. For the successful trigger, I have this conditional statement: "DSJS.RUN...
- Mon Jan 04, 2016 8:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Type Conversion - Ora to NZ - Using RCP
- Replies: 3
- Views: 6053
- Wed Dec 23, 2015 10:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Type Conversion - Ora to NZ - Using RCP
- Replies: 3
- Views: 6053
Data Type Conversion - Ora to NZ - Using RCP
Hi all, I have a job that uses a file to provision Oracle tables into Netezza tables. Below is the simple job set-up: Oracle Connector ---> Netezza Connector I am using RCP and selecting all data from the Oracle source table. In the Netezza connector, we are using the 'Replace' table function. One o...