DSXchange

Hi all

I HAVE to trim trailing special character |
or just replace with blank while trimimg
can any one please let me know the syntax



how to use exactly
Trim(%string%,[%stripchar%],[%option%])

thanks

USE
Oconv(Iconv("9999 12 31", "D-YMD[4,2,2]"),"D DMY[,A3,]") in the transformer

Thanks kumar
so u mean the file should be splitted before using it as a source file to the cff stage according to the copy book and also where should i mention the record type in cff
i mentioned at the redefined field and value in the cff
it would be of great help kumar

thanks

my question is how to split header and detail based on on which record in my case i mean by which column (record type) where exactly i have to specify in stage that one and what value and where in the stage actually that needs to be splitted in transformer according ly by record type what is the rec...

thanks lawrence i really appreciate you

I also have a question that OCCURS DEPENDING CLAUSE could be implemented in server jobs does it support if so whats the approach and also if i the file has bad data how can i capture as i am using a reject link from the transformer to capture them down to a sequential file but i could'nt what's the ...

A column that contains an OCCURS DEPENDING ON clause may be flattened when it is either the last column, or it is followed only by subordinate columns and none of the following columns contain an OCCURS DEPENDING ON clause. In all other cases, a column containing an OCCURS DEPENDING ON clause must b...

hey gurus, i have an instance in copybook (COBOLFILE) 05 ICD-2615-PROVIDER-TYPE OCCURS 18 TIMES INDEXED BY PROV-TYP-INDEX. 10 ICD-2615-PROV-TYPE PIC X(04). 05 ICD-2603-PROVIDER-SPECIALTY OCCURS 36 TIMES INDEXED BY PROV-SPC-INDEX. 10 ICD-2603-PROV-SPECIALTY PIC X(04). 05 ICD-4500-PROC-RANGE-CNTR PIC ...

i was getting error code = -14 so any one know how to resolve it

hi i was given task to upgrade jobs from DS 7.5 to 7.5.1on window s as well as in unix aix,since i havent worked on it i want to know how the migration is done and what are all the factors to be considered while migrating,what type of errrors generally occurs and how to resolve them,if any screen sh...

if column name (varchar) datatype then column name (integer) datatype else integer (datatype). i wrote in the transformer stage If lo.custid Matches ("1970" Or "1971") Then in_data.value Else 0 is it the correct way or not.i have doubt on the quotation marks. if not suggestions p...

if column name (varchar) datatype then column name (integer) datatype else integer (datatype). i wrote in the transformer stage If lo.custid Matches ("1970" Or "1971") Then in_data.value Else 0 is it the correct way or not.i have doubt on the quotation marks. if not suggestions p...

WHILE TRANSFORMATIONS IN THE TRANSFORMER STAGE CAN WE PASS INTEGERED COLUMN TO DECIMAL COLUMN.

thanks buddy
i will work out with that.
thank you once again

DO JOB SEQUENCES COULD BE RUN DIRECTLY THROUGH DIRECTOR WITHOUT USING ANY SHELL SCRIPT TO CALL IF SO CAN ANY ONE EXPLIAN BRIEFLY OR IT IS MANDATORY TO HAVE A SHELL SCRIPT FOR CALLING OR RUNNING 4 JOB SEQUENCES. IF SO CAN ANYONE POST EXAMPLE OF SHELLSCRIPT THAT CALL JOB SEQUENCES IN UNIX AIX VERSION ...