DSXchange

It is varchar()

There is no problem with viewing the data.. I can see the problem is with the records where field2 is '*'. Is there any special handling of * in datastage?

I am new to Datastage.. couldn't quite understand this..

Here are some more details - 1. Input is a Data set 2. Then a filter to get only these two fields. 3. Did not change anything in partitioning (Auto) 4. the order in sort stage is 1. field1 2. field2 5. output is going to a data set via a Copy state. 6. I tried to change the input partition to use Ha...

My data is something like ---

Field1 field2
18834 *
18834 0
18832 *
18832 0

the result is coming as -
18832 *
18834 *
18832 0
18834 0

but i want the result as -
18832 *
18832 0
18834 *
18834 0

the first field is 'Double' and the second one is varchar.

Hi,

I am doing the sort on two key columns, but seems like it is doing the sort on the combination of these columns. What i want is - it should sort on first column and in case duplicate records for first column then sort on second column.

Can somebody help please?

Thanks,
Vishal

If i change the sql type of a field from varchar 20 to varchar 30 and my subsequent job does not need this field. In this case if i change the table definition my subsequent job will require changes even if i am not using the field in the job.

Hi,

I need to get a date_name from user and derive 2 more fields from DB using this parameter. I need to use all these three fields as the parameter for other jobs. Is this possible?

Thanks,
Vishal Gupta

Hi, I have a situation, wherein i am extracting the data from a table into a staging file and doing the following - 1. I saved the table definition for this staging file. 2. This staging file is being used in 20 more jobs for different funcationalities. 3. All these 20 jobs are reading the file with...

Hi,

I need to do the following Oracle functionality in Datastage -
sum(case when field1 = 'X' then 1 else 0) countx,
sum(case when field1 = 'Y' then 1 else 0) county

Is it possible to do this in aggregator stage or i need to put this logic in transformer stage before the aggregator.

Thanks,
Vishal

Thanks! "jwiles" and "chulett"

Hi,

I am trying to import the table definition of 10 tables at a time and getting the following error -
The OCI function OCIStmtExecute returned status -1. Error code: 1,000, Error message: ORA-01000: maximum open cursors exceeded.

Can somebody help?

Thanks,
Vishal Gupta

Hi,

I need to implement the 'Not Exists' logic of SQL in Datastage. How can i capture lookup failure records in a file or is there a way to do this in Join stage.

Thanks,
vishal

Hi, My DS job is creating the Insert statements dynamically. Due to bad design of DB everything in my job including Table name is dynamic. I need to execute these statements on Oracle DB in the parallel job. How can i do that, i tired using Db connector for Pl/SQL but i had to provide it the input f...

I have the following logic to compare the name of two records. Where the file is sorted on name and rownumber, because there can be two groups same name but sandwitched with another group of name. THe below does not work correctly if the stage is parallel StageVar1 = Input.name StageVar2 = (if Stage...