DSXchange

Hi Please can any one help me in this issue, i am working on DS 8 version production jobs and the sequencer is aborted due to the following issue. Issue: seq file stage,0: Unable to open /export/local/dsadm/ProjectName/PRD/Aga/Input/xxx/FILENAME.dat: No such file or directory. [new-impexp/file_impor...

Pls can any one help me, i got This 2 following conditions must validate for Input data file. 1) Input column A Must be 'O13' or 'S10' or space else reject the column 2) Input column B Must be Numeric and If It is > 0 then the column A must be 'O13' or 'S10' Input data file -------------------------...

HI

Please help in this how we can convert character data type to numeric data type in datastage

Thanks

I got this error when compliling my job i got all the access for the file but the error says. Cannot get exclusive access to executable file for job name- job may be being monitored.
pls can any one help me in this issue.

Thanks...........

Hi Please can any one help me in this issue, I am working on datastage 8.1 version and i am working on a job after compiling the job i got the following error in log Please can any one can help me with this Error message: main_program: Syntax error: Error in "group" operator: Error in outp...

hi all

please can any one tell me about what are the difference between datastage 8.0.1 and datastage 7.5.1 version. i new that in 8 version there are some new stages been added. but please can any one tell me that what exact differece is between this two version

Thanks
kk

Hi Please can any one help me with this i am doing the sequential file to sequential file job in datastage parallel 7.5.1 version. i got input file which have two columns got the dates Column A Column B 11/2/2008 4/2/2008 13/2/2008 4/2/2008 7/2/2008 5/2/2008 6/2/2008 6/2/2208 In input if date in col...

hi pls can any one help me in this, i am using the datastage 7.5.1 parallel. i am doing this job in parallel file to file(input file is seq file and output file is seq file) for exp i got one input file in the following format COLUMN A 08/07/2008 07/08/2008 and i need to get output in following form...

hi ex: if u got the date 2008-06-27 and u need to convert it into the 06272008. then u can do it in the transformer by using the stage variables in stage variable properties take 4 stage variables A MM DD YYYY AND derivation of stage variables ---------------------------- derivation side / stage var...

hi ex: if u got the date 2008-06-27 and u need to convert it into the 06272008. then u can do it in the transformer by using the stage variables in stage variable properties take 4 stage variables A MM DD YYYY AND derivation of stage variables ---------------------------- derivation stage variable d...

hi pls can any one can help me in this problem. i got a input date as 05aug08(verchar) and i am using sequantial file as source and the target is also sequantial file. i need to convert the 05aug08(verchar) to 20080805(verchar) in transformer and i am using datastage parallel. i used DateToString(St...

Hi, Question : To convert format of date. 1) 05aug08 to yymmdd and 2) 05aug08 to yyyymmdd Solution: Use this function in transformer It will work. This is for fist one: DateToString(StringToDate(DSLink8.a,"%dd%mmm%yy"),"%yy%mm%dd") Second one: DateToString(StringToDate(DSLink8.a...

DSguru2B wrote:Is your output date or a string format? Lets start with that before we jump any forward.

hi
the target column for the date is in the verchar
thank you

hi i got a file with one header row and one tail row in between this there is a data. and we need to remove the 2 headers and the 1 tail row. the data which is in between 2 headers and 1 tailer should be used as a source sequential file and the target is also a sequential file. and i am using datast...

Read about StringToDate() in your manuals to get an understanding of how these functions work. Your incoming format is %dd%mmm%yy, so you will feed this to StringToDate. StringToDate(in.col, '%dd%mmm%yy') this will convert your String into Date. Now as for your output format, that depends upon your...