DSXchange

Hi Craig, I tried the syntax in the link you provided. Its failing mentioning ": Unrecognized type-specific format properties: {key}" The syntax given for the key field is wrong in the link you attached. I also tried to import a table definition, and defined one column as key field and wen...

Hi Craig,

There is no provision to mention the key in the schema file.
I think it is like that for a while....


Thanks & Regards
Koti

Sorry Craig, Will follow that... Shane, Thats right i am sending the Key columns via parameter set value file. I was able get to a temporary work around, i am passing separate schema file just with keys and using ColumnExport Stage to concatenate dynamically.....As i can't mention the key in my orig...

Thanks Mike,

We are planning max of 5 keys as of now...


Thanks
Koti

Hi Shane/Mike, Once again Thanks for your responses, I got a break through with CDC and RCP.But it is working only with one key field(that i pass through parameter set). Here is my design. SeqFile----Sort-----CDC----Transformer----Modify-----Oralce | | | Oracle I was able to pass the sort keys, CDC ...

Hello all, I am planning to do unix sort in Sequential file filter,but Sequential file is by default read using Sequential Mode, wont that mess up my sorting done via unix?

Hi Mike, Thanks for your input, I too have dynamic number of keys based on table, and i want to follow your approach, exactly how did you generate the concatenated key (Through Parameter Set Values???), if yes , can you give me more details. Just to make things spicy, we want it be NLS Compatiable a...

Hello all,

We are trying to do one single job with CDC Stage(comparing file and db) in it and also RCP Enabled. Did anyone try that, if yes, how did you handle the Hash Partitioning and sorting in it? Any help would be greatly appreciated.

Thanks & Regards
Koti

Hello All,

Is it possible to pass one lookup return value to another lookup within one lookup stage..Because i remember doing it in Server Jobs though the links look red from one lookup return to another lookup,it used to work.
I dont find equivalent in Parllel jobs.

Thanks & Regards
Koti

Hi,
Did any one ran oracle function through stored procedure stage for few records only, and let other records pass through with out any processing? If yes, Can you tell me how did you do it?


Thanks & Regards
Koti

I think we are still unclear as to where this is happening and what is triggering it. It seems to be a executing a TCL shell command but using a UNIX type path. ... Hi all, Sorry for not being clear, the very first time. I am running the batch job control. Inside the batch i am using the DSExecute ...

Can you please post the full, unedited error? And explain when/where exactly it is that you get this error 'once in a while'? Hi all, Sorry it wasn't the job, it couldn't find the dsproject home.Though the file .dsproject is available. Here is the error below. Cannot find DataStage project director...

Hi all,

We get 'Job not in VOC Error' on our unix box once in a while. The same job runs perfectly alright most of the days...Did anyone get this even after DSHOME is set up perfectly...Unix was up and running perfectly when it failed. Please let me know. Thanks in Advance.

Thanks
Koti

Hi roy, Here is the info. client ver: DS EE 7.5.1a DB2: DB2 8.2.3 using DB2 API Stage. It is breaking the connection whenever i set the NLS Map to UTF-8 and giving me 81002 error. Thanks in advance Koti Any chance you can supply more info? Like what client/DB/source are in question + version I must ...

Hi all,

Did anyone know the predefined set of causes, of why the client connection breaks by just changing a setting like NLS Map or any other setting. (Note: we have "Do Not Timeout" checked).

Thanks in advance

Koti