DSXchange

Anyone know how to fix this one? >LIST RT_LOG49 File F:ArdentDataStageProjectsDevelopment/RT_LOG49/OVER.30: Computed blink of 0x800 does not match expected blink of 0xA2F800! Detected within group starting at address 0x53204342! LIST RT_LOG49 09:58:31am 10 Aug 2001 PAGE 1 Severity Full Text............

Does anyone know how to correct this problem? This Job is attempting to move data from universe into a SQL Server Database. It looks like it is failing in the connect to SQL. When I reset the job and run it again, it seems to work fine. > > REPAIRCODE.RepairCode: |REPAIRCODE.CODBCStage2: DSD.BCIConn...

Hello

set the type of the routine to before/after-routine.

regards Udo

Thanks a lot. Although my routine was compiled, I had to close the job and re-open. Rgds,Uma On Fri, 10 Aug 2001 Ray Wurlod wrote : >They dont appear in the drop-down list unless theyve >been compiled. >Also, if you had Designer open when you created the >routine in Manager, the >Designers view of t...

They dont appear in the drop-down list unless theyve been compiled. Also, if you had Designer open when you created the routine in Manager, the Designers view of the repository may not have been refreshed. Re-open the job. If this doesnt work, re-open the Designer. -----Original Message----- From: d...

Hi, How to make a custom before/after sub-routine visible in the before/after sub-routine drop-down listbox in Job properties or stage properties window? In the help file, it is given that the drop-down will be populated with built-in before/after sub-routines. So, I created my sub-routine in the bu...

Hi again Brad,

Not sure if you are already aware of this, but there is a plugin called the "Complex Flat File stage" for reading certain Mainframe files. Im not sure if this would help - I suggest if you are interested you contact your local sales/support office.

Regards

- Chris Thornton

Our architecture involves taking information from IBM mainframe, into a DW and datamarts on an SP2 machine using UDB for the database engine. The primary tool for getting the information from the sources to the DW is DataStage, but may use other utilities as appropriate to augment the tool. Any expe...

This is really pleasing news from Sudhir. Its what Ive been pushing for some time. For full syntax of dsjob see the Server Job Developers Guide. If you type dsjob alone at the command prompt you get the "top level" syntax returned as part of the error message. Similarly if you enter a partial dsjob ...

we have same kind of setup we are also using control-m. we use dsjob to run datastage one main job from unix ( jobcontrol job ) rest of the jobs are called from indside the jobcontrol job dsjob syntax is very simple. thanks and regards Sudhir Mahendru CTI-Banking Systems- IDMS/IDMS-DataWarehouse (65...

Avoid dsjob wherever possible. It is merely an example of how to use the DataStage C API. Prefer job control routines always. -----Original Message----- From: Rahim Ladha [mailto:rahimladha@hotmail.com] Sent: Friday, 10 August 2001 07:34 To: datastage-users@oliver.com Subject: Sample job script Does...

Does anyone has sample dsjob script, in which I can pass my parameters, user, pwd and how to get the return code if its sucess or not. I have to run this on a unix env. Thanks in advance rahim Rahim Ladha e-mail : rahimladha@hotmail.com _______________________________________________________________...

Phil, I have attached a very simple example. Normally in production, a little more care would be taken with hardcoded password values, etc. This is just a guideline. Make sure that your parameters match the numbers and names of the parameters of your job when using "dsjob". #!/usr/bin/ksh ## Purpose...

Hi All,

Does anyone have an example of a UNIX script for calling DataStage jobs that they would be willing to share and if so would they post it to the group? We want to be able to call DataStage from Control-M running.

David, Thank you very much for the response. Yes, you are correct, the routine is fairly large. I wasnt aware of the 32kb limit, thats a good thing to know. I do have access to a newer version of Manager, I will give it a shot... Thanks again for your help. - Vince :^) -----Original Message----- Fro...