DSXchange

Thanks Ray. This looks like just the thing I need. My only problem is that I can't seem to get the JobName values out of the loop. Bolded are my modifications to your code. The first DSLogInfo gives me: "Output = 33 record(s) selected to SELECT list #9." So, I know the query found results....

Hello Everyone My name is Jay Schwan and I am a Recruiter with TAC Worldwide Companies. We currently have multiple openings for Datastage developers in the Detroit Metropolitan area. These are 6 month contract positions working on Datastage and ETL development on Oracle and Teradata. Candidates shou...

Not sure if you can do this with just the functions within DataStage, but you can easily get a list of the job names in a category onto a Select List (= list of keys in memory) and process that list as follows: Command = "SELECT DS_JOBS WITH CATEGORY = 'CategoryName' TO 9" Call DSExecute(&...

Before I hurt myself, I thought I would ask the experts.... I would like to create a job that looks at a specific category in a project and will send an email if there are any jobs that are not in run-able order. Is there an easy way to do this? Detail: I looked at DSGetProjectInfo and can get a lis...

Hi Jozef... I can't say for sure, but usually, if there's an error in the importer, it's truly because the xsd is invalid. There are some strict rules about xsd's, and because we actually use the Apache xalan and xerces xslt and xml processors, we often catch things that other tools don't. Hard to s...

Hi Ernie DS 7 is up and running, but now I'm struggling with the XML Meta Data Importer. Have you got any suggestions on the "Namespace"? I'm reading a XSD file. The error: " is an invalid value for the 'use' attribute Thanks Jozef -----Original Message----- From: ernie.ostic@ascentia...

John, Here is the snippet of code, we use to call dsjob from JAVA program Dinesh Process p = Runtime.getRuntime().exec( MProperties.DS_EXE_PATH + "/dsjob -run -wait -param lowDate=" + lowDate + " -param highDate=" + highDatePlusOne + " -param dsOutDir=" + MProperties.DS...

This means that the number of columns you have defined in the OCI Stage does not match the number of parameter markers in your Custom SQL. -craig -----Original Message----- From: datastage-users-bounces@oliver.com [mailto:datastage-users-bounces@oliver.com] On Behalf Of Dommelen van W. (Wim) Sent: F...

Hi Wim, If you have a Select Script like: ------------------------------------ create table John as select max(name) from Elleen; ----------------------------------- you get this message. You should then write: create table John as select max(name) as Max_Name >From Elleen; after a max(), sum().... ...

Hi All, I get this error while trying to get the highest value of a number-field in the Oracle table using max(name_of_the_field... any idea? testJRNL..Oracle_OCI_9i_15: ORA-24334: no descriptor for this position testJRNL..Oracle_OCI_9i_15.DSLink1: DSP.Open GCI $DSP.Open error -100. Thanx! Wim van D...

The statement "For any transformation in DataStage the input columns should match the output columns in the same order." is simply not true. ----- Original Message ----- From: Aleem M Baig Date: Thu, 18 Mar 2004 08:21:27 -0800 (PST) To: datastage-users@oliver.com Subject: Stored procedure ...

Hi Prasad, For any transformation in DataStage the input columns should match the output columns in the same order. Check your input columns and output columns, the procedure returning the columns does not match your outputs. try running the procedure seperately and look at the no. and order of colu...

I've been told that this is possible, John. Good Luck! Tony "Reedy, John" wrote: We are trying to investigate this, but I am not a Java developer. Can Java build a command and execute it, similar to what you can do with a VB shell command? -----Original Message----- From: datastage-users-b...

Hi All, I am getting the following error while executing Data Stage job. StoreOut..CTransformerStage10: |SQL statement has incorrect number of result columns.| Could please give me the details error Any help wouldbe highly appreciated Thanks&Rgds Prasad*******************************************...

We are trying to investigate this, but I am not a Java developer. Can Java build a command and execute it, similar to what you can do with a VB shell command? -----Original Message----- From: datastage-users-bounces@oliver.com [mailto:datastage-users-bounces@oliver.com] On Behalf Of Tony Stark Sent:...