DSXchange

My 2-cents worth. Build a parameter file for each environment, something like a simple text file. Set permissions on the file so that peeking eyes cant read it. Write a simple routine to set parameters in your job at runtime to the values in the parameter file. This allows you to build a migratable ...

Patricia, This part of our system is not very sophisticated. We simply use the DataStage export/import. However, we do have some practices that might answer you questions. We make all our changes to jobs in dev. We then migrate the jobs to test and prod (and yes, it is VERY tedious). As a rule, we d...

We are using DCS product to migrate our data stage jobs. Since this is our first attempt to move items to production, we were wondering what migration practices other Data Stage users had in place. If using DCS, what do you do with the Jobs that were migrated up from DEV - to TEST - to PROD... (tedi...

We have successfully run tests in our test environment ...with no warnings or errors from data stage. We are now trying to run in Prod...we are running a hash creation job. The validation works....but the RUN gives us a WARNING CONNECTION LOST ! RETURN CODE 15 We also then interrogate JobStatus and ...

Which buffer? If youre talking about the result set buffer for an ODBC stage type, the default is a maximum of 400 columns or 8192 bytes, whichever comes first. These can be varied using MAXFETCHCOLS and MAXFETCHBUFF, respectively, in the uvodbc.config file. If its not this buffer, please post a mor...

Yes, very easily. ALL our jobs have the same three parameters: TargetDSN TargetUser TargetPassword On the OCI stage, put these parameters into the source name, user id and password fields as follows: #TargetDSN# #TargetUser# #TargetPassword# Done! Note, we use the "Target" prefix above to distinguis...

Is there any way in DataStage I can pass database/user/password along with a other parameters using Oracle OCI? thanks in advance regards Rahim Ladha e-mail : rahimladha@hotmail.com _________________________________________________________________ Get your FREE download of MSN Explorer at m

I need to know the max buffer size for DataStage 4.0 and how or if it can be increased. Thanks Lisa Hamilton --------------------------------------------------------- The sender of this electronic message intends that this e-mail be used exclusively by the individual or entity to which it is intende...

One of the many problems with dsjob is that its exit status is a single byte. So you dont get to see the whole error code. So 69 could be 69, 325 (256 + 69), 581 (512 + 69), and so on. You just dont know. In the manual (Server Job Developers Guide) it states explicitly that dsjob is intended ONLY [m...

SQL State is a phenomenon defined within the ODBC Standards. Therefore it is only reported when an ODBC driver is involved (either an ODBC stage or a "native" stage that uses ODBC under the covers). OCI does not fit in this class. About the best you can do is use DSGetNewestLogId() and DSGetLogEvent...

Sudhir, Start with the obvious. Check your login user name and passed word are correct and that the caps lock is not on. After that check the that the name of the host system is correct on the login box. Failing this, is the server machine switch on and running with out any problems. Regards Adele M...

/ > dsjob -lprojects Status code = 69 thanks and regards Sudhir Mahendru GTS/APHO-ITA/CA$H/IDMS-Datawarehouse (65) 423-7449 -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender im...

At 07:13 AM 7/26/01 +0100, you wrote: >This data element is of type "time" and when I use the builtin function >time, I get the same result. I opened up GTAR 34719 for you on this issue. Its currently targetted for the next release of the UDB plug in stage. If you need to track it further, or raise ...

Thanks for that. It makes a difference for the ODBC stage, but I dont have any UDB database (currently) to do the test. It was worth trying though.

This data element is of type "time" and when I use the builtin function time, I get the same result. -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@Informix.Com] Sent: donderdag 26 juli 2001 2:20 To: datastage-users@oliver.com Subject: RE: UDB plug-in : DS doesnt know 24:00:00 What h...