Search found 7201 matches
- Mon Mar 08, 2004 4:35 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Oracle vs datasets
- Replies: 1
- Views: 16633
Oracle vs datasets
Hi Guys, Performance wise which one is faster : read/write from/to oracle table OR read/write from/to .ds. Please let me know. Thanks. Raj ************************************************************************* PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the excl...
- Mon Mar 08, 2004 1:37 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Reference atlas.nextval from oracle
- Replies: 8
- Views: 32302
Reference atlas.nextval from oracle
It's not that it has to be last, it's merely that the job does not provide a column. For example INSERT INTO table (c1,c2,c3,c4) VALUES (atlas.nextval,:1,:2,:3); would suffice, and the job would only supply three columns on that link (values for columns c2, c3, and c4. ----- Original Message ----- F...
- Mon Mar 08, 2004 1:34 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Passing parameters to jobs in batch
- Replies: 9
- Views: 30198
Passing parameters to jobs in batch
It is not possible to get DSJE.BADVALUE if the parameter type is String. I believe your parameter type is TimeStamp, in which case the format must be an ISO8601 TimeStamp (that is, YYYY-MM-DD HH:MM:SS. Yours has an underscore between the date and time components and only a two digit year. __________...
- Mon Mar 08, 2004 9:32 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Passing parameters to jobs in batch
- Replies: 9
- Views: 30198
Passing parameters to jobs in batch
Hi Regu and others.. I've already tried what you have suggested below and the second job successfully picks it up. I also tried running a different Unix command, a wc -l, and can successfully pass this parameter through to my second job however when I run my "head" command and try and pass...
- Mon Mar 08, 2004 8:05 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Passing parameters to jobs in batch
- Replies: 9
- Views: 30198
Passing parameters to jobs in batch
Guys, You may have tries this already, but I would start by running the same bit of code but actually hardcoding the parameter value to be what you expect from your Unix script. i.e. replace "ErrCode = DSSetParam(hJob1, "pFileDate", ProsParam)" with "ErrCode = DSSetParam(hJo...
- Mon Mar 08, 2004 7:49 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Passing parameters to jobs in batch
- Replies: 9
- Views: 30198
Passing parameters to jobs in batch
You are *sure* it is defined as a String? You've spelled the Parameter name correctly or you would have gotten a different error. A string (mostly) doesn't care what kind of values you put in it, so I'm surprised by this error. I *could* see you getting this if it was defined as a Date. Your other i...
- Mon Mar 08, 2004 6:06 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Passing parameters to jobs in batch
- Replies: 9
- Views: 30198
Passing parameters to jobs in batch
Hi David I'm using version 6.0.1.5 I've tried adding quotes using the DQuote() and SQuote() routines but to no avail... Many thanks anyway.. Lawrence -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent: 08 March 2004 11:47 To: DataStage Users Discussion List Subject: RE: Pass...
- Mon Mar 08, 2004 5:46 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Passing parameters to jobs in batch
- Replies: 9
- Views: 30198
Passing parameters to jobs in batch
Which version of DataStage? There was a bug related to parameter passing in an older version (I think it was 4.x or earlier) where strings containing certain characters (we had problems with spaces in parameter values). Certainly, this is fixed in the version we are currently using (5.2.1). If you a...
- Mon Mar 08, 2004 5:39 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Passing parameters to jobs in batch
- Replies: 9
- Views: 30198
Passing parameters to jobs in batch
This is defined as a string. I've tried concatenating a couple letters to the front of my date to see if this works but still get the same problem.. -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent: 08 March 2004 11:31 To: DataStage Users Discussion List Subject: RE: Passi...
- Mon Mar 08, 2004 5:31 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Passing parameters to jobs in batch
- Replies: 9
- Views: 30198
Passing parameters to jobs in batch
OK, I guess the obvious question is ... what type is your parameter pFileDate defined as? -----Original Message----- From: datastage-users-bounces@oliver.com [mailto:datastage-users-bounces@oliver.com]On Behalf Of Ross, Lawrence Sent: Monday, 8 March 2004 9:26 PM To: datastage-users@oliver.com Subje...
- Mon Mar 08, 2004 5:26 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Passing parameters to jobs in batch
- Replies: 9
- Views: 30198
Passing parameters to jobs in batch
Dear All I'm trying to pass a parameter from one job to another. I have a Unix command which successfully returns an output as follows "04-03-07_15:00:00" I'm trying to pass this output into another job called Batch::KalamazooProspects using DSSetParam. See code below. When I run this and ...
- Mon Mar 08, 2004 1:00 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Reference atlas.nextval from oracle
- Replies: 8
- Views: 32302
Reference atlas.nextval from oracle
However, be careful of the performance : if you have a huge number of lines in your stream link, and for each line a lookup is done, your job can take a lot of time to be executed. I have succesfully used user-defined sql (as proposed by Ray) few months ago, but it seems to me that, it works only if...
- Fri Mar 05, 2004 2:38 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: BW loadpack locks jobs
- Replies: 1
- Views: 16083
BW loadpack locks jobs
I had the same problem, but it was always a user who has a lock on the job. So first, check that you have no connections open : on unix : netstat -a|grep uv regards Johan tom.peter.nielsen@nordea.com Sent by: datastage-users-bounces@oliver.com 05/03/2004 08:38 Please respond to datastage-users To: d...
- Fri Mar 05, 2004 1:38 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: BW loadpack locks jobs
- Replies: 1
- Views: 16083
BW loadpack locks jobs
Hi, I have a DS job that is activated by BW. After the job has been run, i'm not able to open the job in the designer. It gives me the "Job BWMappingJob is being accessed by another user" error. I've tried to take down the RFC connection for that sourcesystem, but that didn't help. Is this...
- Thu Mar 04, 2004 9:48 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: How to import files w out editing, for tbl defs
- Replies: 2
- Views: 10649
How to import files w out editing, for tbl defs
One possibility, amongst many.... - Copy just the field labels to a text file. - Create a DataStage Job (you could use QualityStage if you reallllllllly wanted) that would replace any occurrence of spaces and other invalid characters to a character of your choice. - Copy from the new text file the n...