Search found 64 matches
- Sun Jan 18, 2004 7:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: After job subroutine not getting called
- Replies: 4
- Views: 1857
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
- Fri Jan 16, 2004 4:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: After job subroutine not getting called
- Replies: 4
- Views: 1857
After job subroutine not getting called
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...
- Mon Jan 12, 2004 9:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to identify array length in Basic
- Replies: 2
- Views: 1352
How to identify array length in Basic
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
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
- Tue Dec 30, 2003 8:08 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data loading in main and detail table
- Replies: 3
- Views: 1467
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...
- Tue Dec 30, 2003 4:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data loading in main and detail table
- Replies: 3
- Views: 1467
Data loading in main and detail table
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...
- Mon Dec 29, 2003 5:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Informix Stage gives error while simple extraction
- Replies: 3
- Views: 1820
- Sun Dec 28, 2003 8:24 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Informix Stage gives error while simple extraction
- Replies: 3
- Views: 1820
Informix Stage gives error while simple extraction
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
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
- Tue Dec 23, 2003 2:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OraOCI9 stage : accessing Oracle
- Replies: 2
- Views: 1130
OraOCI9 stage : accessing Oracle
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...
- Tue Dec 23, 2003 2:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting error while updating a column
- Replies: 8
- Views: 3139
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...
- Mon Dec 22, 2003 10:11 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting error while updating a column
- Replies: 8
- Views: 3139
- Mon Dec 22, 2003 10:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting error while updating a column
- Replies: 8
- Views: 3139
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...
- Mon Dec 22, 2003 7:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting error while updating a column
- Replies: 8
- Views: 3139
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 ...
- Mon Dec 22, 2003 3:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting error while updating a column
- Replies: 8
- Views: 3139
Getting error while updating a column
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...
- Thu Dec 18, 2003 4:27 am
- Forum:
- Topic: Informix stage
- Replies: 1
- Views: 1248
Informix stage
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...
- Tue Dec 16, 2003 11:51 pm
- Forum:
- Topic: Using transformer stage, reloading metadata
- Replies: 5
- Views: 2141
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...