DSXchange

Fully qualify your path to the output file and see if that works. Yeah u r rite intially that was the problem when i fully qualify the path it worked fine for any shell command. But when i am trying to run a Bteq scripts or perl i have this below error home/apps/z628945/perltest.pl Reply=137 Output...

Okay, this is the reverse on what I assumed occured here. In summary: You have a "BTEQ.sh" script. I know your actual name for that script may be different, but for now, lets assume it is called "BTEQ.sh". You ran this script via your command line, which uses a specific shell (l...

I have a job sequence to run a perl program. On ok i have to trigger another job. Job sequence fails and i don't know y. when i run the same command on the command prompt its run fine but when i enter that on DS job sequence it fails. Thanks Would you please elaborate a bit more on 'failed'? If you...

Environment, environment, environment. Your jobs run under a different environment than when you try things from a command line. You must investigate the environment of the job sequence job to find out what's missing. Write a simple batch or sequence job to execute "env" and find out what...

I have a job sequence to run a perl program. On ok i have to trigger another job. Job sequence fails and i don't know y. when i run the same command on the command prompt its run fine but when i enter that on DS job sequence it fails.
Thanks

But that way i won't be able to make use of the reject link. I am doing something else in the transformations. If i add this into transofrmation its getting more complex This is the type of philosophy that you need to end. This is the ETL world, where things are far easier to implement and try. Why...

I wanted read only those records whose size is 12 and rest all to be rejected(I mean pushed to the reject link). My question is how shoud my schema be ? You are asking how to handle dynamic lengths for a flat file input (i.e. bad fields). 1. Use QualityStage. OR 1. Set everything to varchar of an u...

Hi folks, I am been playing with file stage from couple of days. I have a fixed length file which may have extra length of chars. In the columns of the stage i have mention all the fields as char with their respective sizes since all of my records are of fixed width. And i have a reject link. Lets t...

Folks the thing is when i have to a squential stage for the file with max len of 265 define for columns. For LEN(record string) =! 263 and len(record string) !=265 to work The stage has to out put both the record size to the transform stage, whereas it just gives you only those records that are 265 ...

I have a file of variable length records out of which i have to take out only 2 types of records of size 263 and 265, means all the record whose size are of either 263 or 265 should be filtered out.
How can i do it ?
Thanks

I have given both the fields(f1 & f2) as keys in remove dups stage and its working fine.
I have to store all the rejected records in a separate file. I tried putting a reject link but the remove dups stage take only one output.
How can i get the reject records ?
Thanks
MZ

Hi All I have a sequential file of fields f1 f2 f3 in trasformation i am checking for f1 and f2 for null and then i have to remove dups so i am placing a remove dupilcate stage where we have to sepecify the key on which we are checking dupilcates. I have to delete or remove records which are dup but...

Hi, Yes you can combine PX and Server and I think that is the best solution. 1.I have set of validation on a flat file (record size) If the file is not big, go with server and execute them in parallel. 2.Removing duplicates Use PX with the Stage remove duplicate 3. Finding the new records modified ...

I created a job sequencer in which i have 2 jobs that has to be executed .
But its run only the first job. In the log it say 2nd job executed but i don't see the result. Which indicate that the 2nd job wan't executed.
This is with 7.x on unix

Hi friends, I little confused between server and parallel job. Project 1.I have set of validation on a flat file (record size) 2.Removing duplicates 3. Finding the new records modified and old records in that flat file taking with a teradata tabe. If i select a server job i have easzy interaction an...