Hi,
You can Use Iconv and Oconv Functions as :
Trim(Oconv(Iconv(LinkName.DateColumn,"D-YMD[4,2,2]"),"DYMD[4,2,2]")," ","A")
This will give you the desired output. "InputDate" is the date in
YYYY-MM-DD Format.
Search found 27 matches
- Fri Jun 20, 2008 3:05 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Converting M/DD/YYYY to YYYY-MM-DD
- Replies: 10
- Views: 3623
- Tue Apr 08, 2008 1:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: compile issue
- Replies: 4
- Views: 3470
- Fri Apr 04, 2008 9:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Installing Datastage
- Replies: 10
- Views: 6712
Re: Installing Datastage
DataStage is not supported on Vista yet.vilasini wrote:Hi Friends,
I wanted to install datastage 7.5x2.
I have Windows Vista in my system.Any one can suggeest me can I install datastage on Vista and what and all are required before installing.
Thanks in Advance
Anju
- Mon Mar 03, 2008 9:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Warning _ORA-01861: literal does not match format string
- Replies: 9
- Views: 3939
Re: Warning _ORA-01861: literal does not match format string
Hi, You tried to enter a literal with a format string, but the length of the format string was not the same length as the literal. Re-enter the literal so that it matches the format string. For example, if you tried to execute the following statement: SELECT to_date('20041308','yyyy/mm/dd') FROM dua...
- Mon Feb 11, 2008 3:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSR.ADMIN: Failed to write to project file.
- Replies: 2
- Views: 1823
- Thu Jan 31, 2008 3:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequential file error
- Replies: 9
- Views: 5648
Re: sequential file error
Hi I am trying to remove first line in my input sequential file. i am using filter command sed '1d' to do this. i am getting error saying test..Sequential_File_0.DSLink3: ds_seqopen() - Error in filter command "sed -n '1d'" - test..Sequential_File_0.DSLink3: ds_seqopen() - Error in execv(...
- Thu Jan 31, 2008 3:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequential file error
- Replies: 9
- Views: 5648
Re: sequential file error
Hi I am trying to remove first line in my input sequential file. i am using filter command sed '1d' to do this. i am getting error saying test..Sequential_File_0.DSLink3: ds_seqopen() - Error in filter command "sed -n '1d'" - test..Sequential_File_0.DSLink3: ds_seqopen() - Error in execv(...
- Thu Jan 17, 2008 10:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to change the evnironmental variable
- Replies: 12
- Views: 5583
this Environmental varaible is only for a this particular job Are you sure its an environment variable and not a simple job parameter? Follow These 2 steps : Step 1: 1) Login DataStage Administration 2) Select your project and click on Properties button. Note:- You will get your project properties ...
- Tue Jan 15, 2008 9:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file in PX
- Replies: 5
- Views: 3380
- Wed Dec 26, 2007 2:51 pm
- Forum: General
- Topic: New Year Wishes
- Replies: 15
- Views: 6459
Re: HAPPY NEW YEAR
Happy new year from me as well
- Fri Oct 05, 2007 8:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenating Two datasets
- Replies: 8
- Views: 4379
- Thu Sep 06, 2007 9:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Substring extraction
- Replies: 6
- Views: 3381
Substring syntax looks alrite for me. OutputField=substring [startPosition,len] (InputField) or is this not the right syntax? :roll: Passing job parameter into that syntax can be the issue? Check the type of your parameter in its definition. May be it is other than a string. Use the square brackets...
- Tue Jun 19, 2007 7:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading BLOB data
- Replies: 7
- Views: 5190
Re: Reading BLOB data
Guys, Please help me on this issue. I am trying to read BLOB data from Oracle database. Iam getting the following error while reading the BLOB data from oracle "Internal Error: (colDesc):orautils.C: 1803: getColDesc failed" Is there any solution for this issue. Thanks in advance, Rajesh S...
- Mon Jun 11, 2007 10:24 am
- Forum: General
- Topic: Using DSJ.LINKROW
- Replies: 4
- Views: 2400
Re: Using DSJ.LINKROW
Hi, I'm using the expression DSGetLinkInfo (handleJob, StageName2, LinkName2, DSJ.LINKROWCOUNT) to create new keys for a table, but I need to know how many rows has the original file. The original file (a sequential file) has 13276 rows but the result of the Getlinkinfo column is always -6. This me...
- Fri Jun 08, 2007 12:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle deadlock problem
- Replies: 6
- Views: 2014
Re: Oracle deadlock problem
Hi, I am using Oracle as target with 'User defined update only' option. While running the job with 4 node configuration it's throwing deadlock problem to update approx. 63,000 records . There is no duplicate record in the input stream, what could be the reason ? Thanks in advance ! Ankita Check is ...