Try this....
StringToDate(DSLink3.Testdate,"%yyyy-%mm-%dd")
Search found 27 matches
- Sun Feb 13, 2011 9:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Invalid Format - Date
- Replies: 4
- Views: 6560
- Sun Feb 13, 2011 8:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: subtract one day from date
- Replies: 5
- Views: 19982
- Sun Feb 13, 2011 6:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: compare values in transformer stage
- Replies: 27
- Views: 14820
Re: compare values in transformer stage
Is it possible for you to use the distinct function in the Source when you are getting all these values or do you have specific requirement to do this in transformer stage..
- Mon Jul 20, 2009 12:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reg:Fatal Error in the Datastage 8.1
- Replies: 3
- Views: 4126
Reg:Fatal Error in the Datastage 8.1
Hi, In one of the ETL job we are getting the Fatal Error as : Fatal Error:Not a list value ;table. I was not able to figure out,what was the exact error in the ETL job. About the job design: Basically we are reading the Data from Database table and doing 6 look ups including Range look up on some of...
- Sat Mar 01, 2008 7:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reg:Views
- Replies: 1
- Views: 1718
Reg:Views
Hi all, Can we write the user-defined sql for creating the view inside the odbc stage.If yes means i have done the same thing in the odbc stage. O.S:windows 2003 server Version:DS 7.5x2 Oracle client:Oracle 10g. odbcstage--->copy--->sequential file Inside odbcstage i have given user-definedsql as: C...
- Sat Jan 26, 2008 12:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reg:Parallel jobs Error
- Replies: 1
- Views: 1157
Reg:Parallel jobs Error
Hi, We have installed datastage 7.5 on Windows 2003 server.All the server jobs and parallel jobs are running fine.But the parallel jobs are aborted.And we went and check in the director it was showing the fatal error as: "This jobtype is not currently runnable on this platform Attempting to Cle...
- Thu Dec 13, 2007 8:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query About join stage in PX
- Replies: 8
- Views: 3774
- Tue Dec 11, 2007 8:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: multiple conditions in filter stage
- Replies: 9
- Views: 7285
- Fri Dec 07, 2007 8:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null issue in look up
- Replies: 3
- Views: 1846
- Thu Dec 06, 2007 9:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to enable clean up resource /performance monitor
- Replies: 6
- Views: 3058
- Fri Nov 09, 2007 8:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reg:Datastage doult
- Replies: 6
- Views: 2626
hello sir, Thank you very much for giving this advice to me. As u said i did the same thing,telnet the data stage server.I was able to connect to data stage server using telnet in putty.My o.s is Windows XP professional and the ssh server is cyberspace.com.Could you please guide what is the next ste...
- Thu Nov 08, 2007 8:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reg:Datastage doult
- Replies: 6
- Views: 2626
- Thu Nov 08, 2007 8:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reg:Datastage doult
- Replies: 6
- Views: 2626
- Thu Nov 08, 2007 6:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reg:Datastage doult
- Replies: 6
- Views: 2626
reg:Datastage doult
Hi all, My O.S :Window XP Professional Datastage: 7.5x2 I am having some free shell account in some public site i.e using ssh. Can i connect that ssh shell to our data stage server i mean like telnet ?Is it possible means please let me know?If anyone have an idea please share with me?Thank you very ...
- Wed Nov 07, 2007 10:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error in Viewing the data
- Replies: 5
- Views: 4538