Search found 22 matches

by Obiwon666
Fri Jan 20, 2012 8:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trouble with StringToDate
Replies: 10
Views: 5411

I make a mistake when i write the code. :oops: Good code : If IsNull(Ln_in.col_2) Or Ln_in.col_2="" Then SetNull() Else StringToDate(Ln_in.col_2,"%yyyy%mm%dd") Yes when i use len function, i have 0. Pb for my job it's why i have no null values. My column is nullable. Anyway my wa...
by Obiwon666
Thu Jan 19, 2012 4:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trouble with StringToDate
Replies: 10
Views: 5411

If IsNotNull(Ln_in.col_2) Then StringToDate(Ln_in.col_2,"%yyyy%mm%dd") Else SetNull() I found the error, col_2 contains "" but not the null value. I use this code and it works. If IsNotNull(Ln_in.col_2) or Ln_in.col_2 ="" Then StringToDate(Ln_in.col_2,"%yyyy%mm%dd...
by Obiwon666
Thu Jan 19, 2012 3:55 pm
Forum: General
Topic: Where are DataStage jobs stored?
Replies: 5
Views: 5590

It means files and directory, repository is stored special files.

If have a valid and uptodate dsx export of your project, recreate the project and import dsx it could be better.
Xmeta can have some trouble with only files and directory restores.
by Obiwon666
Thu Jan 19, 2012 3:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trouble with StringToDate
Replies: 10
Views: 5411

Trouble with StringToDate

Hi, Here my situation: Input schema: col_1 integer nullable col_2 varchar nullable Output schema: col_1 integer nullable col_2 date nullable When i convert "col_2" into datatype 'Date' with the code "StringToDate(col_2,"%yyyy%mm%dd")", i have the warning "Conversio...
by Obiwon666
Mon Dec 22, 2008 2:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using RT_LOG with a multi-instance job
Replies: 2
Views: 1304

Thank you, this is this field.
by Obiwon666
Thu Dec 18, 2008 9:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using RT_LOG with a multi-instance job
Replies: 2
Views: 1304

Using RT_LOG with a multi-instance job

Hello everybody, I use file RT_LOG<XXXX> to get message logs of the jobs whatenever their status (Aborted, ...). I use it to generate automatically flat files associated to each job existing in a project (with some codes to parse results). It works really fine. But I am confronting with the followin...
by Obiwon666
Fri Mar 07, 2008 7:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data stage 7.5.1A connectivity with Teradata V2R6.2
Replies: 9
Views: 5670

Hi,

TTU 8.2 is supported and certified with DataStage 7.5.2 and above (7.5.3, 8.0X,..), so it could be the reason.