Search found 152 matches
- Wed Mar 04, 2009 8:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: StringToTimestamp err
- Replies: 23
- Views: 7884
My job is seq file -> tx -> or db table. DSLink8.Eff_date looks like this 2/3/2009.I am trying to use stringtotimestamp function in the transformer.My time part in the timestamp can be default.I tried various combination as the sainath suggested but still i get the same warning. I am on 7.5.1a Than...
- Tue Mar 03, 2009 5:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer Field Limitation
- Replies: 5
- Views: 3055
Re: Transformer Field Limitation
can you post the error you got when compiling in the test environment???
- Tue Mar 03, 2009 5:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp with Microseconds in Parallel
- Replies: 6
- Views: 3218
Re: Timestamp with Microseconds in Parallel
keep the data type as timestamp and select (micro seonds) in the extended property of the column... in you are doing transformation in the transformer(if you extracted the column as a string from db2) ..use the string to timestamp function like this.. StringToTimestamp(DSLink2.name(ex:2008-02-28 19:...
- Tue Mar 03, 2009 3:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp with Microseconds in Parallel
- Replies: 6
- Views: 3218
Re: Timestamp with Microseconds in Parallel
if you are coneverting from a string to a timestamp format with microseconds ..try palying around with changing the default timestamp format in the job properties -->defaults section
- Tue Mar 03, 2009 10:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null value in Sequential file stage..
- Replies: 1
- Views: 1299
Re: Null value in Sequential file stage..
don't go with view data option in the seq file stage to check what is written to the file
what you see when you open the file on UNIX box, is what you have in the file...
or try this
when writing to seq file...set the property under field defaults -->null field value --> ""
and see
what you see when you open the file on UNIX box, is what you have in the file...
or try this
when writing to seq file...set the property under field defaults -->null field value --> ""
and see
- Tue Mar 03, 2009 10:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle sequence resued for processing.
- Replies: 15
- Views: 4028
- Tue Mar 03, 2009 10:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle sequence resued for processing.
- Replies: 15
- Views: 4028
- Tue Mar 03, 2009 10:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle sequence resued for processing.
- Replies: 15
- Views: 4028
- Tue Mar 03, 2009 10:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle sequence resued for processing.
- Replies: 15
- Views: 4028
thanks for your quick response.can you please elaborate about the first stage you have (oracle reference) what is that to do? also in the lookup stage I dont find any option for sparse lookup? can you please elaborate about the first stage you have (oracle reference) what is that to do?---- just to...
- Mon Mar 02, 2009 4:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle sequence resued for processing.
- Replies: 15
- Views: 4028
- Mon Mar 02, 2009 4:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle sequence resued for processing.
- Replies: 15
- Views: 4028
- Mon Mar 02, 2009 3:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle sequence resued for processing.
- Replies: 15
- Views: 4028
Re: oracle sequence resued for processing.
source | | | | Ora(Reference)-----Lkp-------Target ( Lkp type: sparse) (Read Method : User-Defined sql) (SQL Query : select sample_seq.nextval as seq_num from dual) on the Lkp stage map the field seq_num to the ouput field which is unique seq number on the target side
- Mon Mar 02, 2009 3:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle sequence resued for processing.
- Replies: 15
- Views: 4028
Re: oracle sequence resued for processing.
you want to use that DB sequence to create the unique number every time you run one particular job or you want to use that DB sequence in other jobs as well???
- Wed Feb 25, 2009 12:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data getting added in CDC stage
- Replies: 11
- Views: 3128
- Wed Feb 25, 2009 11:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning Message: Cannot preserve partitioning
- Replies: 8
- Views: 11272
Re: Warning Message: Cannot preserve partitioning
set "CLEAR" TO preserve partioning flag on TRANSFORMER