DSXchange

kamalshil

you can do one thing generate report .
Job image will be stored in the folder where u have generated job report.

This might help you.

kamalshil

Then add a reject link to your Oracle stage, make that go through a transform stage whose output is set to abort if more than 0 rows go through the reject link. The abort rolls back the incomplete tra ... Hi I have tried with this solution. After issuing abort also it is inserting the values in the...

kamalshil

Will this override the default behaviour of datastage of commit after 2 sec or 5000 rows.

And will not commit after there is record failure at 6000th record.

kamalshil

Hi, If your stored procedures expects parameters then you need to pass these onto the stage. Typically you will need to have input parameters and output parameters. The data type for the parameters must match up to what the stored procedure is expecting. Other than that it's the same as any other s...

kamalshil

I assume then that you are using the upsert option rather than the load option. In that case, if you don't specify either the APT_ORAUPSERT_COMMIT_ROW_INTERVAL or the APT_ORAUPSERT_COMMIT_TIME_INTERVA ... Ya i tried with the load option. it is rejecting the records with fails unique constraints. An...

kamalshil

ArndW wrote:What stage are you using to write to Oracle, the answer depends upon how you are doing this. Also, is this a Parallel or Server job (I am assuming PX due to the environment variable, but since you pos ...

Its an Oracle enterprise stage.
And parallel job.

kamalshil

Hi, I have an requirement where i need to commit all the rows at once as the job is completed. i have been through the forum and searched for it. there was few suggestion for setting value of environment variable APT_ORAUPSERT_COMMIT_ROW_INTERVAL=0 commits the records only when the job is finished. ...

kamalshil

[If IsNull(Column A) Then SetNull() Else Column A What are you trying to do here as a straight move would be sufficient as there is no arithmetic expression or function where Column A is being used. Check if you have specified column A as Nullable YES in the metadata and if this is a database stage...

kamalshil

Hi All, In my job i have an column A which is decimal 38,0 and nullable yes. But when i am trying to add the null handling statement before loading it to database table. If IsNull(Column A) Then SetNull() Else Column A i am getting an fatal error operator failed. And if i don't do null handling the ...

kamalshil

gssr wrote:Sort the Source file and Aggregate in Country_name Column with Count rows option

Using the Count rows values to fetch the records accordingly

Ok but after doing so.
How can i generate output files as

Code: Select all

OP_UK.txt
OP_US.txt

Containing the data filtered according to values from Country column.

kamalshil

Hi, I have 3 or more sequential file. Each file having an country specific data with country column having country name. Ex: Filename 1 : SP_US.txt Filename 2 : SP_UK.txt And i am reading this in sequential stage with patter : SPD_*.txt [/b] Now i have to generate the the output files according to c...

kamalshil

ray.wurlod wrote:The "$" character will cause DataStage to seek out an environment variable in the project. Is that how your project is set up? ...

Yes.

kamalshil

No they are not in quotes
they are like this

Code: Select all

#$username#

kamalshil

Hi All, I am trying to call 1 stored procedure from datastage job. But if in any of feild for database,password,username or schemaname if i give job parameter. i am getting fatal error. TNS-ORA-Could not resolve. And if i do hard coding it is working fine. So how do i use job parameters in stored pr...

kamalshil

Thanks,
I have used 1st statement as keeping in priority which column may have more nulls.

DSXchange

Search found 177 matches

Commiting records after successful completion of job

Re: Null checking for decimal

Null checking for decimal

Assign name to file at runtime.

Parameters in Stored Procedure Stage