Search found 7201 matches
- Mon Jul 21, 2003 1:23 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: HashLookupRoutine with Variable Arguments
- Replies: 5
- Views: 767
- Mon Jul 21, 2003 12:40 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: HashLookupRoutine with Variable Arguments
- Replies: 5
- Views: 767
HashLookupRoutine with Variable Arguments
Hi all,
Has any produced a routine with variable number of arguments? if so, how do you do it?
Tunde
Has any produced a routine with variable number of arguments? if so, how do you do it?
Tunde
- Mon Jul 21, 2003 10:44 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: problem running jobs (userrights problem?)
- Replies: 2
- Views: 629
Its unlikely to be permissions, though you might like to check that umask setting is the same on both machines. Based on your description, I am assuming you are having no difficulty saving the "adjustments" you make - that is, no error occurs at this time. Are the problems occurring when you try to ...
- Mon Jul 21, 2003 9:37 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: problem running jobs (userrights problem?)
- Replies: 2
- Views: 629
problem running jobs (userrights problem?)
Hi, Weve got the following problem: we have defined two datastage projects, lets say they are called project A and project B. After we developed about 30 jobs in project A, we test all jobs and when everything works ok we export all jobs with executables and import them into project B. Both projects...
- Fri Jul 18, 2003 10:13 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: DSCLinkReport() in plugin stage code
- Replies: 1
- Views: 639
Seems to me that your custom plug-in should call this once for each link, probably once successfully connected, to log information to the DataStage log. Just guessing though as I have no experience in custom plug-ins. -----Original Message----- From: Madhan Mohan [mailto:madhan@iri.com] Sent: Saturd...
- Fri Jul 18, 2003 4:09 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: DSCLinkReport() in plugin stage code
- Replies: 1
- Views: 639
DSCLinkReport() in plugin stage code
I am trying to understand the purpose of the method DSCLinkReport() used in writing plugins. The interface header dscapi.h declares it as ------------------------------------------------------------------ /* * New interface to log details of table updated by DataStage Job. */ DSCDLLSymM DSCBoolT DSC...
- Fri Jul 18, 2003 2:40 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Argument format for function DateFromDaysSince
- Replies: 2
- Views: 2657
Hi Kasia / Kim, "DateFromDaysSince" is a function on the parallel transformer canvas. I have a development system here, and the function is documented in an appendix of the parallel users guide. It doesnt show up on searches of the pdf, probably because the name has been split across two lines in a ...
- Fri Jul 18, 2003 2:02 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Argument format for function DateFromDaysSince
- Replies: 2
- Views: 2657
Kasia I looked DateFromDaysSince is not in the SDK. You need to send source code or try formatting your date field with oconv(). Oconv() can format a date a lot of different ways. You could probably find most of these in the archive. Thanks Kim. Kim Duke DwNav - Navigate ETL Business Rules www.Duke-...
- Fri Jul 18, 2003 10:45 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Argument format for function DateFromDaysSince
- Replies: 2
- Views: 2657
Argument format for function DateFromDaysSince
We need to use the DateFromDaysSince function. We try : DateFromDaysSince function(FieldWithNumber,2003-07-16) : it works When using : DateFromDaysSince function(FieldWithNumber, FieldWithDate) : it aborts ("... apt_conversion date ... : invalid date []" used for DateFromDaysSince conversion) The Fi...
- Fri Jul 18, 2003 5:36 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job aborts without any message
- Replies: 4
- Views: 1315
Sometimes it happens when there is not enough disk space. Kasia At 17/07/2003 15:02, you wrote: >Hi, > >platform : UNIX-SOLARIS 8 >datastage : 5.1 >ORACLE : 8.1.7 > >Ive got the following problem. >I have multiple inputfiles and I process them one by one by executing a >flow of jobs. >Without any re...
- Fri Jul 18, 2003 4:40 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Oracle error
- Replies: 15
- Views: 3103
We are using 4.2 r2. I think in this version each link will create a separate session. Thanks, Bruce --- David Barham wrote: > Oh. Exactly which version of DataStage 4.2? There > are some really bad > releases of the ORAOCI8 plugin in some versions of > 4.2. If you can get up > to at least 4.2.2r2, ...
- Fri Jul 18, 2003 4:15 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Oracle error
- Replies: 15
- Views: 3103
Oh. Exactly which version of DataStage 4.2? There are some really bad releases of the ORAOCI8 plugin in some versions of 4.2. If you can get up to at least 4.2.2r2, you might be better off. The transaction handling in 4.2 (I forget the version of the ORAOCI8 plugin) is different to most prior and la...
- Fri Jul 18, 2003 4:05 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Oracle error
- Replies: 15
- Views: 3103
Hi, Oracle client on ETL server: 8.1.7.0.0 DS: 4.2 We too have many instances where OCI8 plugin is used to load 9i DB. But the error is coming only in few cases, so for those OCI stages we have started using ArraySize = 1. If the error comes at the first run of the job, then it is consistent. Good l...
- Thu Jul 17, 2003 3:01 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job aborts without any message
- Replies: 4
- Views: 1315
You may also get more details on the error from the &PH& directory in the project directory. Regu -----Original Message----- From: Tony Stark [mailto:tonystark622@yahoo.com] Sent: 17 July 2003 15:39 To: datastage-users@oliver.com Subject: Re: Job aborts without any message Sas Tino, Many times error...
- Thu Jul 17, 2003 2:38 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job aborts without any message
- Replies: 4
- Views: 1315
Sas Tino, Many times error messages that pertain to the job will be posted into the job log AFTER you reset the job. Reset your job and look at all the messages in the job log and see if you find anything helpful. Good luck, Tony --- Sas Tino wrote: > Hi, > > platform : UNIX-SOLARIS 8 > datastage : ...