DSXchange

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.

viewtopic.php?t=94259&highlight=DS_JOBO ... be+written

also look at above URL.

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

DataStage is not supported on Vista yet.

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...

Check this, it will help you.

viewtopic.php?t=87751&highlight=DSR.ADM ... oject+file

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(...

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(...

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 ...

Minhajuddin wrote:You can find it in the format tab. It's in the same category as the Delimiter.

You can find it in the Format Tab-->Field defaults-->Null field value (need to select)

Happy new year from me as well

Raamc wrote:Is there any specific stage to execute CAT command from Datastage job.I need to use the final created file(After Concatenating) for further processing in the same job.

You can execute CAT command in the Execute Command Activity.

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...

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...

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...

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 ...