DSXchange

"Here's the SQL format for the procedure call that goes in the User Defined OCI stage; call <STORED_PROCEDURENAME>(:1,:2,:3,:4,:5) " Could you pls elaborate User Defined OCI Stage - Do you mean User defined SQL Query ?? When i use call <Stored Procedure (int a) a: is output parameter It th...

hi, I'm working on Datastage v7.0 and want to call a stored procedure from OCI Stage. some background: - DataStage 7.0 - Oracle 9i - Unix Server - Use Native driver for Oracle and there is no ODBC connection - I don't have knowledge on unix scripts and routines. I have gone through the forum and tri...

Nandu, I think you need to check that again. You have posted the format of timestamp in Oracle than the date. You can obtain the format used in Oracle by checking your NLS_DATE_FORMAT session variable. For dd/mm/yyyy hh24:mi:ss, you can use YourDate : ' 00:00:00', as your date is already in the 'dd...

Your problem doesn't lie completely within DataStage, it is the OCI stage and your Oracle settings. If you do a "SELECT sysdate from DUAL;" what is the format shown, that is what you should be converting to in DataStage. You can then use: Oconv(Iconv(InDate,"D4/DMY"),"<appr...

my job is : Sequential stage -> Transformer ->OCI Stage( Target is Oracle 9i Table). the source date format is DD/MM/YYYY ( eg:01/07/2004) and has to go as is to the target. As per my understanding it doesn't require any use of ocov or iconv functions ....In transformer i just mapped the source fiel...

Hi All, i have flatfiles as sources. These have date fields where the dates are in format DD/MM/YYYY. In the target table the datatype of the target field is specified as DATE. When i loaded the metadata of the target tables,the datatype of these target date fields was loaded as Timestamp. i suppose...

Hi ,
Can anybody help me :

do i need DSN to import table definations if am using OCI for ORacle Stage ?

Or without DSN i can import the metadata and insert the data from sequential file to oracle tables

Thanks for sending your inputs. Can you please share any sample VBA macro which can extract from excel sheets and save them as .CSV files with different sheet names.

Thanks

Nandu

I am provided with an excel sheet that was basically used for reporting purposes. It contains multiple worksheets and is unclean.In some worksheets there are couple of cells that are merged,there are comments in certain cells,some cells have embedded formulas etc...in such a scenario how do i extrac...