DSXchange

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...

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...

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. __________...

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...

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...

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...

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...

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...

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...

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...

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 ...

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...

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...

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...

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...