DSXchange

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

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

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

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

It was an stuipd mistake, there was a space in the logic it's working now. thanks for anyone who looked at this...

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

Thanks for the reply the problem was with the column ledger date so i used to this code and it worked:
[code]Oconv(Iconv(LP_POLICY_SALES.LedgerDate,"D2-"),"D-YMD[4,2,2]"): " 00:00:00"[/code]

Thanks for steering me in the right direction!

Thanks for the reply. It's working but i'm getting an error message saying: Invalid character value for cast specification LEDGER_DT = "31-AUG-07" LEDGER_MONTH = 08 Ledger Month is defined as numeric 2 LEDGER_DT is defined as timestamp 23 this is the code i'm using to get ledger month: [co...

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

Thank-you for the help. it worked when i used the ... .... I got thrown off by the help file, i wasn't really sure where they were going with that. Thanks again for the help

I looked at the help for matches is this what i found pattern must contain elements that describe all the characters in string. For example, the following statement returns an empty string because pattern does not cover the substring "AB" at the end of string: MatchField ("XYZ123AB&qu...

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