DSXchange

But again here in OCI stage when you select 'Enable Transaction Grouping' the 'Rows Per Transaction' is grayed out and the value '1' stays their though you change it to '0' before it grayed out.

Houston we have a problem here !!

But Craig,

Are u asking about 'Transaction Size' next to 'Array Size' or 'Rows Per Transaction' in the last tab ?

If 'Transaction Size' next to 'Array Size' : I thought 'Transaction Size' is DS old way of handling data and it is still left their for backward compatibilty.

Am I wrong ?

I have the worst case of moving one of our Production boxes to a new machine as their is some kind of hardware issue. We have some 40-50 tables which are using KeyMgtGetNextValue() to insert the Surrogate keys. I can go into the ware house and get the max()values and start the keys from that point. ...

Hi Ray, It is simple job that reads from the previously built Hash-file and writing into the ORACLE table using ORAOCI stage. There is also a look-up but that hs nothing to do with the derivation of this column. This column in derived from the hash-file which has the data. it is still weird that the...

I don't know whether you can get the subfolder list from Folder stage or not. but you can get it from other ways.

if you are on windows machine you can redirect Dir to a text file and parse that file to get the list which is a hard way though ... but it works

Let me make myself more clear. I have some 40 coumns in the hash file and the above 4, I mentioned happened to be 4 out of 40. My Hash file is fine and it has key. Everything is fine except for one row which has a space in its 'Phys_City_Name' -columns and so the next column 'Phys_State_Cd' is getti...

None of them is a primary key column. I gave a part of metadata information for the hash file, there are many other coulmns in the hash file.

You can't set a Job Parameter from inside a job, even in a before-job subroutine, as at that point the job has already started and it's too late. A couple of ways to accomplish what you need... You can write a routine to pick up the value from your file and then return it as the output of the routi...

From where are you calling the Routine ? is it from before-job sub-routine ?

Can you post the cariables and their derivation you are using ? for this ..

I will talk a look into it.

I have 4 coulmns in Hash file: Phys_Street_Name, Phys_City_Name, Phys_State_Cd, Phys_Country_Cd Wilson, North Wilson, NE, US For the above I see data from DataStage data browser for all the four columns. But when I run the job, DS is coming back with warning saying that it cannot insert null value i...

As far as I know If you have proper stage say DB2 8.0 is avilable for you in DataStage 5.2 you need not upgrade the DataStage server engine. Though DB2 8.0 is not avialable you can connect to DB2 8.0 using approp ODBC drivers then I think you can get it work. But the performance will be an issue in ...

Did u give it a try with stage variables and RowProcGetPreviousValue() ?

I think that should work. In the constraints you should have a condition

RowProcGetPreviousValue(NewPolid) <> OldPolid

to write into output.

IHTH

check the box: 'Clear before writing'. In this case the Hash file is totally cleared and built from the start.

This is a safe option than having a way to delete the file at the end of the job. Unless you have hard disk space issues you don't want to delete a hash file after the job.

If you are writing into a Sequential file before update/insert into DB2, that process will wait until the file is fully ready meaning that Seq -> Db2 will happen once: LP -> Seq is finished only. I believe I am not wrong. that is how is the typical behavior of Sequential files and Hash files. if tha...