DSXchange

Hi James, What do you think about concatenate the different parameters that you have to use and parse it in the Before/after stage routines? Best RGDS to everyone Giovanni Boccia Sales Engineer Direzione Industria e Servizi Datamat - Enabling Your Future ----- Original Message ----- From: "Ricketts,...

Hi, Define all required parameters as job parameters and use it with #parameter# in befer/after stage/job routines. It should work. Rgds Saravanan "Ricketts, James" cc: Subject: Before/after stage routines 17-Oct-2001 03:37 Please respond to datastage-users Sender Info: No Sender Info found in the a...

I havent used this much, but one thing I can think of, is to move the control from the job to the before / after job routine shell script. If you have more than one thing to do, put it in the shell script, so that you still run one shell script as a before / after job routine, but the script then go...

Hi again,

Can we export only one job from a project that have many jobs? Is dsexport limited by project, or we can achieve one job inside the project?

Thanks

NP

Hi all,

What are the options to unlock a locked job?
Do we have to kill all sessions and reset DataStage?

Thanks in advance.

NP

Dear all Before/after stage routines provide a single parameter for use at execution time. What hints or tricks do people use where its appropriate or necessary to provide multiple parameters? Cheers James This email and any files transmitted with it are confidential and intended solely for the use ...

Oracle and UniVerse (DataStage) handle dates differently. Oracle has a DATE datatype which holds date and time. This is held internally as the number of days (or fractions there of) since some time in ancient history. The fractional component represents the part of a day, for example 0.5 represents ...

Thanks! I will contact Datastage and ask them to send me the new dsjob. I tried the option of creating .pwd file but it does not work. It does not seem to like even the -f option. Naren -----Original Message----- From: Hall, Doug [mailto:Doug.Hall@anheuser-busch.com] Sent: Tuesday, October 16, 2001 ...

Now thats an easy question. The simple answer is "no". (Unless someone added this without telling me). -----Original Message----- From: Bibhu C [mailto:bibhuds@yahoo.com] Sent: Wednesday, 17 October 2001 8:52 AM To: datastage-users@oliver.com Subject: Question on User Defined-SQL Hi All, This is aga...

Hi All, This is again a question on User defined SQL in an OCIstage. An example of the same: "INSERT INTO TableX (COL1,COL2,COL3,COL4) VALUES (:1,:2,:3,:4)" My Question is : Instead of the position specific bind variables in the VALUES clause, can we use named variables ? e.g. "INSERT INTO TableX (C...

This is a known DSJOB bug. A scheduler, like Maestro, runs an "su user" command and after that the DSJOB command seems to lose track of the user and fails with an "80011" error that, I believe, is a low level security error message. Below are some of my notes: Case 1) The user uses telnet to log int...

I have a situation where my target dates is derived from two source dates. Here is the logic. 1. Target_DT1 = max(Source_DT1, Source_DT2) ("max" should work similar to the "greatest" function in Oracle) 2. Target_DT2 = Target_DT1 - 1 second e.g. If my source row is Source_DT1 Source_DT2 10-10-2001 1...

Hi dsjob (-run or -jobinfo etc) of a job does not work when I run it from a telnet session but it works when I run it for the same login id from an XTERM session (Hummingbird). The error I get is " ERROR: Failed to open project Status code = 80011". Has anyone encountered this? We are on a HP-UX env...

Hi all, I have a hash file with three columns, Col1, col2, col3 with col1 as the key. I use this as the lookup to obtain the value of col2, When I run the job, it gives me an error message Abnormal termination of stage HR1Testjob.xfmPA0002HRTabdest detected There can be multiple values in the source...

Ray, When I import the metadata, it is binary 10. In the GUI jobs I have to change it to Char(20) and put the hex() function in the SQL of the source. When I try this in DataStage BASIC (by BCI function calls), I get errors. In the Systemtables of UDB, I can see how the tables and fields are defined...