DSXchange

If you dont REALLY want the file, you an manually remove it as follows: 1. Use CT VOC DW_MASTER to list the two OS files that comprise this file. One will begin with D_ (probably D_DW_MASTER) and the other should be DW_MASTER. These may or may not be fully qualified paths. 2. From the OS level, rm -...

I accidentally left out the other detail... 5.1 is the upcoming release that will become available in the next few months. Ernie -----Original Message----- From: ernie.ostic@ascentialsoftware.com [mailto:ernie.ostic@ascentialsoftware.com] Sent: Wednesday, August 01, 2001 2:30 PM To: datastage-users@...

Can you rm it from the Unix level? If so, dos os, then delete the VOC entry and start over. If you have any questions or comments please feel free to contact me. Thanks Z John Zygmunt jzygmunt@oxhp.com 800-889-7658-1-6873 -----Original Message----- From: Vincent, Brad [mailto:BVincent@dmc.org] Sent:...

Hi Tracy. It may be that there are some discrepencies in the 4.1 documented codes, but moving forward, here are the codes from 5.1, one of which you ran into (96). #define DSJS_RUNNING 0 /* Job running */ #define DSJS_RUNOK 1 /* Job finished a normal run with no warnings */ #define DSJS_RUNWARN 2 /*...

I goofed on the creation of a hashed (or so I thought) file in UniVerse to use with some DataStage testing. This is on a UniVerse box that does not have DataStage, but we access it remotely via DataStage. Anyway, I suspect I created the file incorrectly in the first place and now see that I cannot d...

Hello, I am running DS v4.1, and had taken this list of job status codes on faith as being complete: /* jobStatus values... from ardentdatastagedsdkincludedsapi.h dated 11/17/99 */ #define DSJS_RUNNING 0 /* Job running */ #define DSJS_RUNOK 1 /* Job finished a normal run with no warnings */ #define ...

Hi all,

May i, in Designer, access the enviroment variables set in Unix Shell? For example, if i have set in UNIX shell a enviromnent variable LOG, how can i access it in Designer?

Thanks in advance,

P.S.: I dont want to pass the variable LOG as a parameter.


NSP

Vivek, you can put logic into your batch job that is polling for files to also poll an ETL specific directory for flag files. If youre on UNIX, you can simply use touch to create a file in this directory that has meaning to your batch job. In your cycling logic, check this directory for the existenc...

Use option 2. Create a "Flag" for the job. Check for its existance. If it is there, the job is still processing and you abort the job. If it does not exist, create it with a beforejob subroutine. Remove it when the job exits with an AfterJob routine. Cheers Ray Daignault. ----- Original Message ----...

Hi all, I am devising a mechanism by which my ETL job polls for the availability of data on the source system. There are two options that i can think of to achieve this: 1) I call this job from a control job in an infinite loop....If data is available then the ETL begins, else nothing happens...and ...

I am currently using the infinite loop to produce real time data for 3 separate batches. I modified the batch properties to also allow for a sleep time overnight during our scheduled maintenance window. I have had a few problems with jobs aborting, however, most of them were due to circumstances bey...

can give the parameter list like this... dsjob -run ???? -param UserName=$UserName -param Password=$Password -param Branch=$Branch Regards Karthi ---------------------------------------- Message History ---------------------------------------- From: nuno.pimenta@tmn.pt on 01/08/2001 11:07 CET Please...

Hi all,

How do i pass to dsjob more than one parameter?

dsjob -run -param ????? -jobstatus exTest exJob

Thanks all,

NSP

Ricks got a good point about exposing passwords in a text file, but UNIX and NT permissions do allow an easy method for controlling access to specific files. Setting up a parameter as type ENCRYPTED will keep DataStage from exposing a password. A sequential parameter file is EASILY source-code contr...

Were currently using the SAP/R3 Extract Pack Plug-in ver.2.0.2 for DataStage 4.2.1 for NT platform. Could you pls let us know if its possible to exchange the data set created by SAP using the "LOCAL DATA FILE" functionality? Consider that DataStage Server and SAP Server are located on the same machi...