DSXchange

josh, I have put the same syntax on the top what you have specified,but I am getting 0 as output. I have used the stage varibale like this input.filename stagevar1 index(stagevar1,'.',1) stagevar2 The data type I have specified as varchar for both the stage variables,I tried with specifying integer ...

my job design is like this

seqfile------->transformer----->sequential_file

If I will use rowgenerator please suggest how I will generate data for the column having .(dot)extension?

Thanks rafique
As I have mentioned on the top job type is parallel.
If the function is avaliable in the transformer do I need to go for the subroutine?

Hi all, I am not getting the proper output while using index function. My source data contains data like this ------------------------- file_name,file_type abcd.txt,txt efgh.csv,csv -------------------------- I want the output like this ------------------------------ file_name,file_type,occurence ab...

Colin and Josh, thanks for your time and input. Strange but true, I could not figure out what was making it to aggregate all similar records into one but I started a new job from scratch and went through the stages in steps and could not recreate the problem. As for the XSD and multi-occurence const...

Hi All,

IBM Support have confirmed that BigInt is not supported in DataStage. As a work-around, we are doing the relevant processing in an SQL stored procedure outside of DataStage, although it is triggered by an event within our DataStage flow.

Thanks,
sjordery

Hi Ernie & Group, Thanks a lot for your inputs. Much appreciated. The recommendation by Ernie to force an attribute works fine. That was helpful. As you mentioned, this does not use the XSD information to interpret the NILLABLE property at runtime, but relies on prior information (coded at desig...

Hi all, I have two sequentila file as source and I have to add the no of rows present in both the source files and store it in a target file. There is no common key present in the both sequential files. Can anybody suggest what should be the design approach? Withou using routines is there any other ...

Thanks Maveric its working fine nw.
Can you please specify what was the problem?

Hi all, I am getting the follwing error(warning msg) in the sequential file(out put) while running. ----------------------------------------------------------------------------- Sequential_File_31: When checking operator: A sequential operator cannot preserve the partitioning of the parallel data se...

thanks ray.Can you please send me the exact syntax I have to specify in the script .

As I have mentioned I also have to collect the no of rows passing through a particular link plus some other statistics like start date,end date of the job.
So will this -report option in dsjob help me to collect the above stastics about the job please suggest?

Ok is there any other option to collect the job statistics in the unix script.
Please suggest.

Hi I tried to collect the job stastics using a script. This is the script which I have used to run the job and collect one stastics no of rows passing through a link. #! /usr/bin/sh dshome=`cat /.dshome`; export dshome PATH=$PATH:$dshome/lib; export PATH . $dshome/dsenv dsjob -run Phase1 test_job li...

Hi Cetin,

Thanks.
How ever I tried to search the forum,but nt able to get the exact solution.
Can you please send me the exact search keyword for this.