DSXchange

meena

Hi All, We are loading data from a DOS files to many different tables. The job runs fine but the problem is when we see the data from SQL Plus we are getting " Carriage Returns " into the Column where we are pointing the last field from the file. We have many jobs which are loading the dat...

meena

Thank you Nick & Craig..

The routine is working with a change from Ans=Output to Ans=Output<1>

meena

Hi All, I have requirement where I need to send an email based on the record count of the file. If record count is 2 then I need to send an email...I am using below routine for word count of the file...While testing the routine the output is 2 but when I am using this routine in the sequencer with t...

meena

Hi,

Code: Select all

 SV1:column1
 SV2:If SV1=SV3 then 1 Else 0
 SV3:SV1

 Constraint::SV2=0

Check this. Else you can do a search in the forum as this is discussed many times here..

meena

Hi,
The error shows that the table name you assinged is not in the database you are referring. Check with the database and the table name.And also check the parameter values..

meena

Hi,
We do not have back up of jobs as well as they are not into version control. Probably we need to try with system restore..

meena

Good Morning,
Few jobs got deleted unkowningly. Is there any way to get back them.

meena

Hi,
What exactly are you doing in the job. After loading the data into sequential file are you able to view the data. And also check with the "Update action".

meena

Hi Craig,
Actually I was trying to redesign the job. Yes as you said this is because of the key not defined. One of the column used as the look up is not defined as a key in the first job. I have changed it and now everything is running fine.

Thanks a lot.
Meena

meena

Hi DSguru2B,
I did use trim and also tried it with internal conversion. But I am getting same problem of fields data moved to next field(hash file after job run) only for date lookup fields.

Thanks,
Meena.

meena

Hi All, I am extracting the data from table (oracle) and creating a hash file.This hash file is used as a lookup in other job with the table(oracle). I have date fields in the hash file which are used as lookup. The date fields of hash file and date fields of the table are in same format. But I do n...

meena

Thanks Ray & Craig,

Both logics worked for me.

regards,
Meena

meena

Good Morning.. I am designing a job which has to handle duplicates. Job design: Extract data from sequential file to load into oracle table( using DRS Stage) and a transformer stage to check for constraint & for some transformations logic. Logic: For handling duplicates I am working on stage var...

meena

Maneesh,
I think user defined query would be better instead of using transformer stage for this.

meena

Good Morning Kris, I want to go with the second way provided by you. But I have question in this. How can I provide the column value as parameter to the routine.Do I need to do this in transformer stage using any specific DSfunction or ?..Can you please give me a clear picture on this. Thanks in adv...

DSXchange

Search found 420 matches

Carriage Returns...

Return Value from the routine...

Re: stage variables

Job delete

Lookup on date fields.

Stage variable on duplicates..