DSXchange

Hi, I have a column name is Full name i want to split the full name into three columns First name,middlename,last name. Here is the data, john bbb colian sam donald 1. first row is contains the first name ,middlename,last name. 2.second row is first name,lastname my source data is sequential file. i...

Constraint: @INROWNUM = Cnt+1 Stage variable. IF @INROWNUM=1 then (id = ' : SourceRead.ID : ' and dt between ' : stdt : ' and ' : ednt: ')' else SrcFilter : ' or ' : '(id = ' : ID : ' and stdt between ' : ednt : ' and ' : mdot: ')' i am passing this stage variable into column in the tranformer. i ne...

sorry not windows.
target file is storing in the unix directory.

i am getting output from Sequential file stage like this i am passing a parameter to the job is 'DD','RR', It is working fine. my output is like this new_id= 900 dt_id beteen 1000 and 2000 or new_id= 800 dt_id beteen 4000 and 6000 when i give like this 'DD','RR','##' It is not returning any rows.How...

i tried in this way, Cmd = ('ksh ':Arg1:'/two.sh') Call DSExecute("UNIX", Cmd, OsOutput, OsStatus) Ans=OsOutput now i am getting the ouput.actually the problem is USER1 USER2 Dastage(unix) username Datastage(unix) username. user name: duser1 user name :d2user1 I created my script in the us...

i changed the permissions of the two.sh to full rights in the UNIX. If i want to get the rights to access from DATASTAGE to UNIX i checked in the Datasatge Administrator(did not see any options related to Access rights). How can i give the rights.how can i check in the datastage. i checked that opti...

i tried in this way. $INCLUDE DSINCLUDE JOBCONTROL.H Cmd = ('ksh ':Arg1:'/sh two.sh') Call DSExecute("UNIX", Cmd, OsOutput, OsStatus) Ans=OsOutput OUTPUT TEST #1 ******* Arg1 = /home/bells Test completed. Result = ksh: /home/noones/sh: cannot open When i test the routine it is showing cann...

i am getting the same error..

"[ ! -f ${File_Name}]"

when i use this sytax in the basic. it is '!' will trat as Dimension of array.
Thats way i am asking the syntax


thx

can you please give some information how i can give the syntax in the Datastage rountine....
thx

File_name="*.csv"


can you please tell the actual syntax.just take as an example.how can we check the file format is correct or not.
thx

this is the script is used for checking the files with an extension is *.csv ext="*.csv" if [ ! -f ${ext} ] then echo 'filename not found' exit 1 fi How can i convert this script in to the datastage... If [ ! -f ${File_Name}] Then Call DSLogFatal('Filename not found.' , c_routineName ) End...

i tried with that one...
it is not going through......

please give some suggestion...

ftp -n ABC.BBC.KL.COM << ! user eucan_ftp_test eucan_FTP_t3st bin put /data/home/test/sample/sample /data/target/test/sample bye i need to send the files from local machine to ftp server when i run this script..i am able to send the normal files(no extension) example: sample test1 ..but i am unable ...

ksh

thanks,
but my requirement
we need to use only ZIP.
we dont use the TAR,GZIP...
Please give some suggestion.
cheers