DSXchange

Sainath.Srinivasan

An ora-0001 is a primary key violation. I do not see any chance of this error occuring without any rows passed to the target. Maybe you are generating rows which is not in the source. Normally these errors are accompanied with the data row that triggers them. Take a copy of the job and replace the t...

Sainath.Srinivasan

Then refer to the initial post which said to have understood.

Also in future please post what you did and the full output rather than saying that 'it does not fit your requirement'.

Sainath.Srinivasan

What was the initial value you set the stage variable to ?

Sainath.Srinivasan

Code: Select all

svCurrKey = input.Key
svOutputId = if input.Port_Id = 0 And svCurrKey <> svPrevKey Then svOutputId + 1 Else svOutputId
svPrevKey = svCurrKey

In the output link,
output.Port_Id = If input.Port_Id = 0 then svOutputId Else input.Port_Id

Sainath.Srinivasan

From monitor.

Sainath.Srinivasan

Search for DS_AUDIT.

Sainath.Srinivasan

You said that you made both as non-nullable. That means that your new function is identical to your old one - except for the new input parameters. If that does not work, you need to start by removing them. By changing the return type from char* to char, you are making the pointer of return value to ...

Sainath.Srinivasan

Obtain the max id in another job and pass its value to the current job.

In this job, set the stage variable to do a normal key change check but control incrementing the id and setting the target as for only when Id = 0.

Sainath.Srinivasan

'03' is only a displaytype for integers. You can do something like

Code: Select all

SELECT to_char(yourIntField, '00')
FROM yourTable

Sainath.Srinivasan

Version 5 had memory constraints of limiting the routine arguments. Due to this, there was a routine written to check any issue routines and provide to list.

As long as you do not have any trouble-creating routines, you must be ok.

Sainath.Srinivasan

chulett wrote:Sai, re-read cuckoo's last post. I edited it slightly for clarity and to emphasis the points they were trying to make.

Craig,

I think the solution provided will work for
"Address (Occurs 3 Times)"

Sainath.Srinivasan

One method may be to parse the occurs into long strings using stage variable and pivot it. This is assuming that your max occurs is finite and managable. Something like NAME ADDRESS (Occurs 3 Times) Can be parsed in following steps 1.) stage variables svOccursPosition = index(inputString, "(Occ...

Sainath.Srinivasan

Does the cobol structure has a depending on clause associated with it ? If not, declare n address subset variables as placeholder. That must be enough whilst reading from the file. Assuming that your input has Address OCCURS 3 times and the datatype is CHAR (say 50 length), you can declare 3 variabl...

Sainath.Srinivasan

system() for C

Sainath.Srinivasan

To obtain valid feedback using datastage macros of datastage, the commit must be controlled. That will slow down the performance.

Search found 3329 matches