DSXchange

So, what are you trying to do? What stage?

The error pretty much says a lot:
"This step has no datasets."

Thanks for your reply.

The table is already loaded but now what about that nested sub query? Any clues on executing that in "User defined query" in Oracle stage?

Hey Guys, I 'm basically writing multiple group-by queries to get my data. The code goes as mentioned below: select subquery.columnname (select columns from table name group by coulums) group by colums where count (subquery.column) > 2 This above is then joined to a seperate query which is written i...

Hi All, we have designed a simple job that loads data into a table using ODBC stage from a file. The records are imported from the file successfully , but it is unable to load in the database . The table to which it loads has been created in the database. The job is getting aborted with the error C...

The \r indicates that the file originated on a Windows system. Change the record delimiter string to \r\n ... Thanks Ray. It worked! Could you please elaborate on the cause of error? It should have been pretty straight forward with import of data but it just didn't work. The extension of the file i...

Hey Guys, I 'm trying to extract a .dat file with fixed with format using a sequential file stage. I have set all the relevant properties including the actual size of all the files. eg. 110 bytes. But, whenever I try to do a view data and I get the below mentioned error. >##E TOIX 000158 17:14:59(00...

Each stage has its own functionality. Some functionalities can occur in different stages. I know of no such document, besides going through archives and learning for the suggestions of our gurus here. For eg: a modify stage is to be preferred over a transformer. Sort stage over in built sort operat...

Hi Everyone, I 'm pretty new to DS development. I had two questions: --> What is the best practise to select what "stage" would be appropriate to do various calculations,etc --> What is the best practise to set performance benchmark? Are there any books/articles besides you guru's that mig...

Thanks for your reply Craig.

Apparently there were some files missing from installation folder. I checked my old install folder and copied files across and now it works like a charm :D

Thanks for your assistance....

Thanks Chullet for your prompt reply and warm welcome. :D Well, the old version wasn't so old may be the same version. But, I have removed all its traces so it shouldn't be a problem with the install. Yeah, I found that MS KB as well :)..let me give it a go... Thanks mate. Update: Now it goes till 9...

Hi Everyone, I 'm trying to install DataStage 7.5.x on Win XP SP2 and I keep getting the above mentioned error. Also, I had a version of DataStage installed on my pc which used to work just fine but uninstalled it since license had expired. I have installed the .net fix but it still doesn't work. Pl...