DSXchange

Hi, I am trying to call the following UDB stored procedure from an ODBC stage: VOBA.SP_GET_DB_LIABILITIES(IN varRptDt DATE, OUT SQLCODE_OUT INT) I am using user defined SQL and when I try call VOBA.SP_GET_DB_LIABILITIES('2006-03-31',?); I get LOAD_GPFRI_DATA..ODBC_14.DSLink2: DSD.BCIOpenR call to SQ...

Thank you for the information!
Just want to make sure of one thing.....The $PROJDEF will be coded in the individual jobs(designer) and that will automatically get the current value coded in the Administrator?

The values were hard coded...

Hi Meena,
I have hard coded them in administrator. When I import the User Defined environment variable in the various jobs it brings in the hard coded value I used in Administrator. Should I not be doing it this way?
Thanks - - John

Hi, I am in the process of rolling out our first DataStage project from Dev to QA. In the administrator I define a set of parameters with defaults and imprted them into the various jobs that needed them. When I created the project in QA I updated the defaults for the parameters(in Administrator) but...

Thank you all for all the advice. I not only receieved the answer to my question but tips on how to proceed with executing jobs remotely.
Thanks again!!

Thanks Avishek...It makes sense that the server must be running. They were thinking they could create some sort of standalone exe.

Re: the scripts/commands you shared below....
Could you execute DS jobs running on Windows 2003 Server from a Unix box as well?

My question actually boils down to.......
You shut down the DataStage Server....could any of the jobs be executed on another machine?

Hi, Is it possible to execute DataStage jobs(exe's) without connecting to the DataStage Server at all. I didn't think this was possible, but one of our consultants thought that this is possible as long as the proper dll's were copied as well. He suggested to management that we could create EXE's on ...

Thank You Kduke! I have been using parameters where I could....one of the many tips learned on this site.
Thanks again.

Good Morning! I am running datastage on Windows Server 2003 and have installed it on the C: drive (C:\Ascential\DataStage) and all projects have been written to the Projects folder in that directory. Last week I noticed that the server ops folks only allocated 8GB to this share. I asked them to upgr...

Thanks Kris!!!
I am running 7.5 and the UtilityHashLookUp utility worked perfectly.

Hi, I have a UDB table that users will be updating regularly and I need to extract a single date from. This date will end up being used in the where clause of a Mainframe DB2 query(90 million rows total). Look-up doesn't seem practical since my result set will only be ~100k rows. Is there any way to...

Hi, I am currently loading to many DB2 Tables who use a Sequence to extract the Key field. I am using user-defined SQL for all these inserts ==> INSERT INTO PRFWSTG.JPTEST(JP_KEY, JP_NOTE) VALUES (NEXTVAL FOR PRFWSTG.SQC_JPTEST,?); Is there anyway to use the NEXTVAL function in the TRANSFORMER deriv...

Seems like it is security policy specific to Windows 2003 Servers. This was not part of the administartion guide, IBM technical support just send it to me and it solved the problem. Hope it can help someone else. Instructions to set up permissions & groups for Windows 2003 Servers --------------...