DSXchange

This might give you some pointers: http://www.dsxchange.com/viewtopic.php?t=85578 Yeah the script which kcblad gave was very useful...I also had developed a less complex script which worked for me with the file watcher concept if you do not have any parameters to pass Generally you need to search f...

You can set them as job parameters in server jobs, but they will have no effect whatsoever. You need the "regular" DB2 environment variables, not the APT ones, which are only for parallel jobs. For server jobs, it is enough to have the environment variables (such as DB2INSTANCE) set in th...

I am trying to understand a few things related to the configuration file. SAMPLE: { node "node1" { fastname "my_fastname" pools "" resource disk "/fs_stage_dataset/Datasets" {pools ""} resource scratchdisk "/fs_stage_dataset/Scratch" {pool...

I am using DB2 i series as database and I have set the DB2 path in my .profile for connecting to the database from Unix. For the Datastage also I am able to connect to database - ( We are using DB2 connect). Now in Enterprise edition I remember we had to setup the following DB2 variables.... $INSTHO...

My question actually boils down to....... You shut down the DataStage Server....could any of the jobs be executed on another machine? You need to connect to Datastage server..if you shut the server down by uv -admin stop then you cannot execute a datastage job You can do it from scripts..you have t...

ALPHAnumeric was specified in the subject. Sorry I pasted the wrong one............ Input = VarCharField ********************************************************** *The function gets the non-numeric fields from the Input* ********************************************************** Charac= Iconv(Inpu...

ray.wurlod wrote:dsjob -run project jobname.invocationID

Thanks Ray and krish..I would try with this...

This is another way in which you can do it........... Input = TRIM(aNUMBERFIELD) ********************************************************* *The function gets the non-numeric fields from the Input* ********************************************************* Convert= Iconv(Input,"MD") ConvStat...

I didn't mean to create 20,000 jobs. Since you say you have 20,000 dealers I am assuming you would have around 20,000 files and would need to run the same job that many times. Allowing a job to be a Multi-Instance job allows you to do exactly what you want. All you have to do is go to the job prope...

You can create the job as a Multi-Instance job and then pass the invocation id as a parameter from the command line. Wouldn't that solve your problem? Thanks Kris but I do not want to create a physical job...each job in my casew ould be for a Dealer and I have say 20,000 Dealer so that would be hug...

Hi I have a requirement to run a single Datastage job sequencer for different files for in same format at the same time... But I do not need to create physical job sequencers for each one...I am scheduling the Job sequencers via Unix cron using DSJOB -run How can I call the same job from Unix script...

Hi Kenny, Do I really need to write a loop statement again? I already wrote a working script that does the job. Wouldnt it be enough just to execute the script in DS? I also included a delay in the unix script. Please advise Julia In your script you need to check the return status...say I generally...

You can ru thru DB2 Stage using the Custom SQL or using load sql at run time option ..... Using this option can I load any sql file as a parameter from any directory on my server box ? hi akshyat for your project.. :lol: .I know you can do it from Datastage sequencer..after the DLR_ID got loaded ju...

The ICONV(In.DateStringColumn,"D4/YMD") function will return a number if it can be converted to internal format or will return the original string if it cannot. I had once developed a Basic routine to check valid format and then convert from a string. This routine is for DB2...it takes an...

Look at your tnsnames.ora file, use the short name of the SID or the longer name, sometimes it looks like "xxxxx.world" or "xxxxx.abc.net". Look at the service_name value and try that. Hi TNSNAMES.ORA is the network configuration file- you need to have it defined at your client ...