DSXchange

ulab - You must be running a serious backlog.. Replying a question after 7 years...

Help me upderstand... what is DataStage contribution here... Is DataStage used to call above command?

Just out of curiosity: Why would you convert from Oracle EE to Oracle Connector? My assumption is Oracle connector will be faster then ODBC connection but it will be slower then Native connectivity like Oracle EE. Same is true for DB2 connector also.

Are you writing this code in a Stage Variable? Looks like that since I see the Stage Variable name in your code and not link name. I am surprised you can even able to compile this code on Windows. We had a similar code and job would not even compile on AIX in 8.x environment though it would run fine...

If your database is not partitioned you do not have option of using DB2EE Stage. If you are on 7.x version your only option is to use DB2 API stage unless you decide to use ODBC. For 8.x you have an option of using Common Connector stage which sits somewhere in between DB2EE and DB2 API Stage as far...

In this particular case it's the CATEGORY index on DS_JOBS that appears to be out of date. That's (my guess) why "the job is not being found in the category". ... Hi Ray, I have done the reindexing on my Dev env. And you'd be surprise to hear that after the reindexing, not a single job wa...

Yes Ebcdic to ASCII What you are looking at is data file. Why you need is COBOL Copybook to create metadata and this metadata will be used to read data file using CFF stage. Using CFF stage you can also convert data from BINARY to ASCII. COBOL copybook is a simple text file which you can read using...

Hi, When I run the job I am getting following error.There is no clue in the log.(some times its working fine).Please anybody can help. Sorce is Dataset and some transformations and loading in to Netezza database. ERROR: ORCHESTRATE step execution terminating due to SIGINT Parallel job was aborted T...

Hi Craig, Sorry for my ignorance! Is that in the Environment variables of the Administrator do I find the Inactivity Timeout? If yes where in the Environment variables? If no where in Adminsitrator? It is on the General tab of your DataStage Administrator client. You can also set it to "Do not...

Hi All, There is a requirement where i need to find count(A) group by(B). A and B are two columns in the file. The aggregator stage is allowing me to grp. by B , but how can I find the count of A as the count rows property of the aggregator stage does not allow me to specify the column name. Lookin...

You set the Inactivity Timeout in the Adminstrator for the server instance, and must be 'dsadm' (or equivalent) to change it. ... Just want to add... You will have to recycle DataStage engine for new Inactivity Timeout to take effect. Also if a job is locked you can try unlock it yourself. In most ...

I kept my first post short enough that I thought it would show in its entirety. Just write your column to a file and use spaces as your line terminators, then read that file using space as a terminator. That way, DS will read each word from your original column as a separate line. This is really go...

Thanks Arndw for your response but, I can't see your response as I am not a Paid member. If you can please post the complete message here that will be really helpful for me. csrazdan, Input row is space delimited between words. I need to write each word as a row to the target database. there is ano...

Questions: 1. You have to insert each word in table as a column or as a row? 2. If columns, them what has to be done if number of words are more than columns? 3. What is delimiter between the words? Is it space? 4. Does the file contain only this field or it has some other column also. In short want...

The delete stmt works fine in toad and also I have created a DataStage job just to delete the rows and it works fine, looks like it doesnt work in OPEN command! I'm not questioning your delete statement. What I want to know is if you can create procedures on this database? I'm not sure but it looks...