Search found 12 matches
- Thu Jun 18, 2009 2:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: stored procedure
- Replies: 6
- Views: 2505
Also if i go to database and select the Stored Procedure Icon and i click on properties i get a the details. The Database Vendor in the drop down there is only Oracle, but the stored procedure is on an MYSQL database, i try to type in mysql but i get an error that says please enter a valid database ...
- Thu Jun 18, 2009 2:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: stored procedure
- Replies: 6
- Views: 2505
Chulett, Thank-you for the reply.... If I go to Edit -- Job Properties--- General Tab and select After-job subroutine: and select ExecSH. In the input value box i'm not sure what I would write there to execute the stored procedure. I'm a basic user of datastage and still trying to learn as i go. If ...
- Thu Jun 18, 2009 11:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: stored procedure
- Replies: 6
- Views: 2505
stored procedure
I tried searching through the forums but the answers seem to be a little over my head. What i'm trying to do is i have a datastage job that goes oracle-----> transformer-----> SQL once the job completes i want to trigger a sql query that executes 4 stored procedures. SQL Query that i want to run aft...
- Tue May 13, 2008 2:37 pm
- Forum: General
- Topic: Invalid Character value for cast specification
- Replies: 1
- Views: 1743
Invalid Character value for cast specification
I'm getting this error: [DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]Invalid character value for cast specification I know that it's trying to insert data into a column that is not the defined as. My question is i don't get any details of the record is just recieve this error: Sa...
- Mon Nov 05, 2007 9:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Quarter Function
- Replies: 2
- Views: 1911
- Mon Nov 05, 2007 9:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Quarter Function
- Replies: 2
- Views: 1911
Quarter Function
I'm was looking at the help file for a way to find out the quarter from a date, and this is what i found. [quote]Q outputs the quarter of the year as a number from 1 through 4.[/quote] So in the transformer i used this logic to get the quarter: [code]Oconv(Iconv(LP_POLICY_SALES.LedgerDate,"D2-&...
- Fri Nov 02, 2007 2:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Question about month
- Replies: 5
- Views: 1746
- Fri Nov 02, 2007 12:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Question about month
- Replies: 5
- Views: 1746
- Fri Nov 02, 2007 10:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Question about month
- Replies: 5
- Views: 1746
Question about month
I'm trying to extract month from the date. And i'm having trouble. My date is coming as following:
31-AUG-07
I been using Oconv(date, "D M[2]") but it's not working. I need to return 10, is Oconv the right way to do this?
Thank-you
31-AUG-07
I been using Oconv(date, "D M[2]") but it's not working. I need to return 10, is Oconv the right way to do this?
Thank-you
- Mon Sep 10, 2007 1:40 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Like statement in transformer
- Replies: 6
- Views: 3451
- Mon Sep 10, 2007 1:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Like statement in transformer
- Replies: 6
- Views: 3451
- Mon Sep 10, 2007 10:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Like statement in transformer
- Replies: 6
- Views: 3451
Like statement in transformer
I have a mircosoft Access database that picks up a file and formats it into a sequential file for me. That sequential file is than ftp to the server and datastage runs. This job is only run once a month. There was a request to change one of the columns and i need to use a like statement i tried to d...