Search found 42 matches

Go to advanced search

by lak4u
Wed May 13, 2009 9:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regular Date To JulianDate
Replies: 11
Views: 4865

ArndW wrote:Have you tried the inverse function,

Code: Select all

OCONV(ICONV("2009-04-06","D4-YMD[4,2,2]")[b]-1900000[/b],"DJ")[code] ...[/quote]

Can you please elaborate ? what is [code] ?
by lak4u
Wed May 13, 2009 8:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regular Date To JulianDate
Replies: 11
Views: 4865

Can you break up the problem into 2 steps, first the ICONV and then the OCONV? When you get "109096" what function do you use and do you convert it to a display date or a DataStage internal date? ... Thanks for reply. I am able to converting OCONV(ICONV("109096" + 1900000, "...
by lak4u
Wed May 13, 2009 8:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regular Date To JulianDate
Replies: 11
Views: 4865

Regular Date To JulianDate

I need to convert DataStage current Date (2009-05-13) to JulianDate Example: from source I am getting Date: 109096 i.e. 1900+109 =2009 096 = 0406 (April 06) I am trying below but I couldn't get it... Oconv(Iconv("2009-04-06","D4-YMD[4,2,2]"),"DJ") FOR JulianDateToTimeSt...
by lak4u
Sat Jan 03, 2009 9:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup error
Replies: 3
Views: 1766

Lookup error

When I lookup with the table(sql server) I am getting following error... anybody can help?

Could not map table file "D:/DataStageFilesystem/Datasets/lookuptable.20090103.q2tvyqd (size 7995709648 bytes)": Invalid argument
by lak4u
Sun Dec 21, 2008 10:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not accepting NULLS while using IsValid or NUM functions
Replies: 7
Views: 1945

ray.wurlod wrote:What if you use something like the following for an int8 result?

Code: Select all

If IsNull(InLink.TheString) Then -1 Else IsValid(InLink.TheString, "int32")
...
Its created NULL value as '-1' and actual values all Zero's

0
-1
0
-1
0
-1
0
0
by lak4u
Sun Dec 21, 2008 8:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not accepting NULLS while using IsValid or NUM functions
Replies: 7
Views: 1945

Regard all Transformer stage functions as intolerant of null. Please be specific about what you tried and what you mean by "doesn't work" (including any error message). The approach that was su ... Hi Ray, My source is varchar with null values(example: 1234,NULL,4321,NULL) Target is integ...
by lak4u
Sun Dec 21, 2008 1:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not accepting NULLS while using IsValid or NUM functions
Replies: 7
Views: 1945

laknar wrote:first for null values first and then go for NUM Function

If IsNull(Columnname) then setnull() Else ......
Thanks for reply but I tried this way too but still no use,I am not sure whre exactly the problem,please help
by lak4u
Fri Dec 19, 2008 11:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not accepting NULLS while using IsValid or NUM functions
Replies: 7
Views: 1945

Not accepting NULLS while using IsValid or NUM functions

If I am using IsValid or NUM functions for cheking Integers it does not allowing NULL values,please help.

Thanks
by lak4u
Fri Dec 12, 2008 12:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Load performance in SQL SERver
Replies: 1
Views: 648

Load performance in SQL SERver

I a m trying to upset 100,000 records to sql server 2005 table,but its taking 3 hours time,actually I need to load 13000000. anybody can help please
by lak4u
Sat Dec 06, 2008 9:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error
Replies: 1
Views: 927

error

anybody ca help me about this error..

APT_CombinedOperatorController,0: Fatal Error: I/O subsystem: Open of /C=/IBM/InformationServer/Server/Datasets/Item_Promotion.dat.Prasad.M.KTMSDBDV01.0000.0000.0000.3430.cb047a0c.0000.2e3078db failed: No such file or directory
by lak4u
Sat Dec 06, 2008 9:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compile error--invoke GenRuntime using phantom process helpe
Replies: 13
Views: 23071

compile error--invoke GenRuntime using phantom process helpe

Hi

I am getting following error while compiling my job.please help

Failed to invoke GenRuntime using phantom process helper
by lak4u
Fri Nov 07, 2008 9:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading Excel file in ODBC - windows 2003 -DataStage 8.1
Replies: 1
Views: 1854

Reading Excel file in ODBC - windows 2003 -DataStage 8.1

Hi, When I try to read excel file in ODBC I am getting following error,anybody can help please.. Error executing View Data command:##E IIS-DSEE-TOSH-00003 09:25:46(006) <main_program> Syntax error: Error in "odbcread" operator: Expected IO redirection, pipe, semicolon, or end, got: "'...

Go to advanced search