DSXchange

In many cases jobs are called by Batch, sometimes jobs(in other category) get aborted due to many reasons like locks on some table, some ORA error.. etc

Is there some way to get exact reason of job failure how that can be implement in the Batch.

If you are using select query than use NOT NULL constraint on each column that you are selecting

there are many option to get rid of this 1. in DataStage Administrator choose correct project then go to Command and Enter DS.TOOLS . from the first menu use option "5" and from the second menu that appears choose "11"th option and then enter your job name correctly, rest DS Admi...

In DataStage Administrator after login Choose correct project in project tab and then hit properties button there check on "auto-purge" check box and put time(days) when you want to purge log automatically

What i got frm ur Q is: U want to process the batch job(as it is meant to) if abc.txt is present and abort the job if the file is absent.. than simply append this code at the stating of ur bacth.. OpenSeq "<filepath>" To Temp locked FilePresent = @True End Then FilePresent = @True End Else...

say u have 25 sites name and there corresponding Site code in written in a file smthng like: <Site name>| <Code> google|1 yahoo|2 AOl|3 so on... than you can use ReadSeq to read one line at a time and store site_name in one param and Site_code in other param.. And as you have said your job is multip...

What do you mean by "Distinct site codes".. and how is your source file stored..

What i got frm ur question is how create target tables based on input site names.. One Way.. $Create a table with column name "Site id", "Site Name". $Then through a job write these table rows to a Sequential file. 'pipe' seprated $Use a Bacth Job $In Batch Job Read input from th...

If you have all the dates stored in a file then use this code in batch datefile=filename with fullpath Openseq <datefile> to <tempfile> ReadSeq Rec from <tempfile> else eof=1 Loop Until eof ipdate=Field(Rec, "|", 1) 'call the job and pass ipdate as parameter to it' Repeat WEOFseq <tempfile...

what i get from ur question is that u want to create table based on the i/p values... What u have to do is to use some parameter say "ipdate" and pass it to target stage where you can have ur table creation query and ur query will look smthg like: Create table #ipdate# <column name> <col t...

i think ray is correct..

Ask your mail-server/firewall admin, possibilities are there they might be blocking outbound mail traffic from source other than outlook..

Confirm with ur DBA on which schema he has created the view....

Case might be the username/password you are passing to the DSjob may be for schema other than on which view resides...

do you want to make the rest job to be run in multiple instance then just enable the option in job to be run in multiple instance...

i was thinking if this could handle in the Batch job itself bt some code.. else to put values in a hashfile i have a to create another job to populate hashfile and some addtional code in the batch job

i think none get what my problem is: closer look: step1 :a loop runs for counter=0 a instance(1) is created which pick a unique value from file and assign it to variable 'param'. step2: when a loop comes again for counter=1 again a instance(2) is created that pick next value than that picked by firs...