DSXchange

Thanks ArndW....
I have changed char to varchar datatype, now the data is loading correctly.
I have been trying this for 2 hrs.. but i could not get an idea you are really great hats offfffffff :D

Hi, Spaces have been identified between the column values when the data is loading into sequential file file name SYD.csv. actual file format should load like this "00089","klllllllll","00089 klllllll" "78909","iiooolllllll","78909 iioooiiiiiii&...

Hi, Is there any built in function that how to convert from julian date format to date(mm/dd/yyyy) source field julian date value TaxDate 103127 target= sequential file target field datatype value TaxDate Date <<mm/dd/yyyy>> i have tried OConv(TaxDate,"D/MDY[2,2,4]"), but not converted exa...

this is the routine i am writing down here ************************************************************ **does the following things **1) write a sequential file containing date,inputrowcount and output **rowcount **2) calling shell script file ********************************************************...

hi tony, my intention is already ExecFTP.sh contains the following parameters ip=$1 username=$2 password=$3 localDir=$4 remoteDir=$5 strfilename=$6 the above parameters i need to call from a afterjobroutine as 6 input arguments. here MY routine is like EXFTP001(ip,username,pwd,localdir,remotedir,str...

Hi, I need calll the file ExecFTP.sh (contains korn shell script) through a routine. and that routine i need place it in afterjob routine and run it with by passing arguments in input values of that routine. here i have two doubts. 1) shell script containts 6 arguments like ipadress,username,pwd,rem...

Hi, what does this error says main_program: Warning: the value of the PWD environment variable (/apps/Ascential/Projects) does not appear to be a synonym for the current working directory (/apps/Ascential/Projects/TIP). The current working directory will be used, but if your ORCHESTRATE job does not...

Hi,

I could not find Ascii function in functions in Type Conversions as i need to convert EBCIDIC to Ascii.

But i have seen the same Ascii function in Server job conversion functions.

Is there any alternative function for converting from EBCIDIC to Ascii in Server Jobs?

Thanks in advance....

Function(ExtRowCount,LoadRowCount) Ans = ExtRowCount LdRowCount = 0 OPENSEQ '/apps/Extract.txt' TO SeqFilePtr THEN NULL ELSE NULL WEOFSEQ SeqFilePtr ; INPUTDATE = OConv(@DATE,"D2/") ROWCOUNT = Ans LdRowCount = LoadRowCount WRITESEQ "Date: ":INPUTDATE ON SeqFilePtr ELSE CALL DSLog...

i put the above code in routine and it's working fine i mean creating a sequential file and writing the contents.
but output of the file is not clearly writing name "Date" before date value
File format
04/05/05 (Date name is missing)
RecordCount:443

Thanks chulett Is this correct syntax i am putting down my code here OPENSEQ '/apps/global/Extract.txt' TO SeqFilePtr THEN NULL ELSE NULL WEOFSEQ SeqFilePtr ; ROWCOUNT = DSGetLinkInfo(DSJ.ME,StageToCheck,LinkToCheck,DSJ.LINKROWCOUNT) INPUTDATE = OConv(@DATE,"D2/") WRITESEQ "Date :&quo...

Should we write the code in after job subroutine itself like without using shell script file .sh
creating a file
adding contents Date and rowcount

Hi,
How do we create a control file in after job subroutine through shell scripting

The file format should look like this(suppose file name extract.ctl)
Date: 04/05/05
Record Count: xxxx

Thanks in advance....

Hi, I am extracting the data from DB2 Database table with the following query like... SELECT CMMPU,CMMKU,CMLDA FROM FIN017 WHERE ASCII(CMMPU) = 'HT'; here the field CMMPU data type is in Binary. it is giving an error ASCII Function is undefined name. could anyone give me exact conversion function fo...

Thanks roy...
I got the rowcount.. but performance is dam slow as we have 7.2 million records at source file. can we take any performance tuning?