Search found 7201 matches
- Wed Mar 24, 2004 7:53 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job info for a specific category
- Replies: 5
- Views: 26769
Job info for a specific category
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....
- Tue Mar 23, 2004 4:26 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Datastage Emlpoyment Opportunites
- Replies: 0
- Views: 16320
Datastage Emlpoyment Opportunites
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...
- Tue Mar 23, 2004 1:52 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job info for a specific category
- Replies: 5
- Views: 26769
Job info for a specific category
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(&...
- Tue Mar 23, 2004 10:52 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job info for a specific category
- Replies: 5
- Views: 26769
Job info for a specific category
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...
- Tue Mar 23, 2004 7:25 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: XML Pack 2.0.1
- Replies: 4
- Views: 23502
XML Pack 2.0.1
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...
- Tue Mar 23, 2004 3:34 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: XML Pack 2.0.1
- Replies: 4
- Views: 23502
XML Pack 2.0.1
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...
- Fri Mar 19, 2004 9:38 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Java API
- Replies: 6
- Views: 26783
Java API
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...
- Fri Mar 19, 2004 6:36 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: 'no descriptor for this position'
- Replies: 2
- Views: 23712
'no descriptor for this position'
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...
- Fri Mar 19, 2004 6:16 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: 'no descriptor for this position'
- Replies: 2
- Views: 23712
'no descriptor for this position'
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().... ...
- Fri Mar 19, 2004 6:01 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: 'no descriptor for this position'
- Replies: 2
- Views: 23712
'no descriptor for this position'
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...
- Thu Mar 18, 2004 3:35 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Error in Assertion
- Replies: 0
- Views: 15085
Error in Assertion
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 ...
- Thu Mar 18, 2004 10:21 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Stored Procedure
- Replies: 1
- Views: 16464
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...
- Thu Mar 18, 2004 8:01 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Java API
- Replies: 6
- Views: 26783
Java API
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...
- Wed Mar 17, 2004 10:38 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Stored Procedure
- Replies: 1
- Views: 16464
Stored Procedure
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*******************************************...
- Wed Mar 17, 2004 4:07 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Java API
- Replies: 6
- Views: 26783
Java API
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:...