DSXchange

Hi, Then how should I use the subroutine I have created. It takes three parameters. Reads filename from first parameter. uses second file to get additional information and creates file with the name of third parameter. Please guide. can I call this thorugh job control window. If yes, how? Girish Oak

HI, I have created one subroutine I am using as After/Before job subroutine. My routine takes three parameters and processes it. When I created function or routine It worked fine. But when I tried to use as before/after sub routine. It is not getting called. any specific way to call such routine. Ho...

Hi,

I want to find out the length of an array is their any way to find out the array length in Basic. Is there anything like Ubound?

Also wanted to know can I return an array as an output of routine.
and how to read this array.

Thanks in advance

Girish Oak

Hi Ken, Sorry to say but I have already gone through these topics before posting this topic. I dont want the concept, I want to know how we can hadle this through in datastage. Currently, I am doing data migration for my client. We have decided a deadline to migrate data as 31st Dec 03 after that we...

Hi, I want to load the master table as well as detail table. Details table contains foreign key whose primary key is in main table. Also, the I want to create primary key (can be numeric value, I dont mind) in main table dynamically while loading the data in main table. In that case I have to use th...

Sorry ray and Ken, I will search the topic next time before posting a topic.
With regards

Girish Oak

Hi,

I am using Informix stage for simple select statement to fetch data from table. Always it gives warning as follows:

testInfx..InfmxCLI_0: This data source does not support transactions.

Can anybody tell me why this warning appears everytime.

Thanks in advance

Girish Oak

Hi Kenneth, Before posting a topic on Oraoci9, I searched the topic for OraOci9 connectivity. I found the following topic http://www.dsxchange.com/viewtopic.php?t=85123&highlight=oraoci9 In which, you have mentioned that we have to settings in dsenv file, what kind of settings do we need to do t...

Hi Ken, Actually I also want to use OCI stage only but currently facing a small problem while using that. I am going to post a topic for the same. Currently, as mentioned above ODBC also works fine but throws warning if row to be updated doesnt found. I am worring about that. If you could focus on t...

While using Update existing rows only got following warning messages OakUpdateMagent..Trx_AgtCode.lnk_Magent: DSD.BCIPut call to SQLExecute failed. SQL statement:UPDATE ANIL.DM_AGENT_M SET STRBOOKINGREFNBR = ? WHERE (STRAGENTCD = ?) 0 Rows affected. STRAGENTCD = "1009617" STRBOOKINGREFNBR ...

Hi Kenneth, I am trying to use user-defined sql. I have only two columns coming as an input for the stage. I want to update second column's value when first column's value is value from column one. hence I wrote the sql like this Update tablename set columnname=:2 where wherecolumn=:1 And this error...

Hi, I defined both columns in the ODBC stage. But still gives the same error. Can anybody help me out. Its really urgent. Special request for Kim, Kenneth and Ray to look into the matter. I am using ODBC stage Thanks in advance Girish Oak This is a OCI column versus SQL statement (columns) mismatch ...

Hi, I am getting following error while updating table. I have only two columns. I know its Oracle error, could anybody help me to resolve this. OakUpdateMagent..Trx_AgtCode.lnk_Magent: DSD.BCIPut call to SQLExecute failed. SQL statement:UPDATE ANIL.DM_AGENT_M SET STRBOOKINGREFNBR = :2 WHERE STRAGENT...

Hi, I want to work for a client having Informix as source system. Client has datastage installed.(I hope Informix plug-in also exists along with that). Just wanted to know that " Is extracting data from Informix similar to extracting data from Oracle using OCI plug-in? ". Can anybody comme...

Hi Kenneth, Copy over the derivations (really easy if your columns are all in the same position) to the temporary link. Is it possible to use Ctrl+C and Ctrl+V for copy pasting purpose. One more thing, is the same thing is applicable for source stage :?: because you have specifically mentioned as ta...