DSXchange

Hi , Iam Reading a file in FTP stage, the file format is as follows 0,FileName,02/16/2006 1,reet,ertt,wrwt,ewter,3445 1,rete,dtgd,dg,dgdgf,356 1,dgd,gfh,gfb,ghgfn,4567 9,3 Always header has three columns 0, filename and file date. trailer has 2 colums 9, total number of details. I have to make the e...

Hi

Thanks Ray, It worked,

Put cat as the command and #directory#/test as the command line arguments'

Thanks
Sri

Hi Kumar,

You are correct i dont need to check the total, Just i want to check the order.

The count of detail records are not fixed , it may be 2records in a set or 6 records in a set. But there should be only one trailer for a set.

Thanks
Sri

Thanks for your response.

I have to check the sequence. If any trailer is not there, or the trailer is between the details, then i have to reject the file. and abort the job.

Thanks
Sri

Hi, In a CSV file, I have to check the sequence of the file. The file is having lot of seperate set of data. each set should have detail records followed by the trailer record. For example, the below is set of data.But the same set can repeat in the file. The detail records always have there last th...

Hi,

I have to give the file name as a parameter, but in execution command activity, i cannot give parameter.
cat /tmp/test --- working, but i need like this
cat #directory#/test.

please suggest me some other way.

Thanks.
Srividhya

Hi,

Use the execute command in job sequence , get the tail or head of the file using the unix scripts .
then pass the ouput of the unix script as a parameter to the 2nd job using
Execute_command .$CommandOutput

It works for me .

Thanks
Sri

Hi Thanks for your quick response. MY "IF NUM(In.VarCharField) THEN In.VarCharField ELSE 'rej'" it is working fine. But when iam passing a null value then it is getting rejected, but i dont want the reject. Iam not replacing the empty string with any other value so ISNULL and ISNOTNULL is ...

Hi , Iam using a FTP file stage to read the input file. Th File is having 70 columns, iam reading everything as varchar. I have to validate the amount and date columns. I have to reject the amount and date columns if they are varchar and i want to keep the null amounts and null dates. In my file I h...

Hi

It worked.
Convert(@FM,"",Execute_Command1.$CommandOutput)

Thanks
Sri.

Hi, My parameter type is string. date format is also correct mm-dd-yyyy in my query iam having select * from xyz where date = to_date ('date_param','mm-dd-yyyy') when iam executing the job and passing the parameter its working fine. but when iam executing in the sequence iam again getting the same E...

Hi tardifma, Thanks for your quick response. I tried this but iam getting the following error checkroutine..JobControl (@Coordinator): Summary of sequence run 11:27:49: Sequence started (checkpointing on) 11:27:49: Previous_date (COMMAND cat /tmp/test) started 11:27:49: Previous_date finished, reply...

Hi , I have two jobs. My first job output is a DATE. I want to pass this date as a parameter to my second job to a oracle stage . In the second job oracle stage i have a user defined query "select * from the XYZtable where the date ='#date_Param#'". I tried various options 1.Iam working in...

Hi ,
set the INITRANS to more then 2 in oracle setting since you are runnind in 2 nodes. ALTER TABLE INITRANS 3

it worked for me
Srividhya

Hi ,
I have job1 and iam using the job1 in seven job sequence. when iam running all the job sequences at the same time. Then iam getting the job sequence getting aborted with the error message. How can i handle this position.
please throw some light

Thanks in advance
srividhya