DSXchange

We have a problem while using this DB2 bulk load, please let me know what is the solution to this problem The error is as follows DW_CUST_INFO_FBLK..DB2_UDB_CUST.IDENT1: Internal Error: Function 'put_row_to_buffer' failed 'put_row_to_buffer' DW_CUST_INFO_FBLK..DB2_UDB_CUST.IDENT1: Error occurred whi...

Suppose if no rows were processed that is the number of rows to the input link (lets take the case of error processing then) will the after SQL still get executed???

Thanks
SCK

Hi All,
If I use multiple instances or invocations of the same job then How can I generate Surrogate keys be generated, the what is the way if the Oracle Seq.Nextval not available.

Can anyone suggest on this please

Thanks
SCK

Hi All,
How do I execute Stored Procedure in Sybase from DS PX Jobs.

Thanks
SCK

Hi All,
If I use multiple instances or invocations of the same job then How can I generate Surrogate keys be generated, the what is the way if the Oracle Seq.Nextval not available.

Can anyone suggest on this please

Thanks
SCK

Hi

Is it possible to use SEQUENCE.NEXTVAL within OracleOCI stage without using WriteMethod=Upsert.

The thinking being that using WriteMethod=Load, I can get better performance. Also WriteMethod=Load does not allow me to define a USER-DEFINED Query

Thanks

Hi All I am able to read the Sequential file data in One Server Jobs with the one MD, but when I try to view the data for the same with the MD for Sequential file in DS Parallel jobs then its throwing an error saying that ##W TOIX 000000 13:48:33(000) <Sequential_File_0,0> Field "SYR" has ...

Hi All, Could anyone let me know what this error could be. This occured when I was trying to load data into Oracle. Oracle_Enterprise_2,0: system(sqlldr legacy_user@prepdev1.world CONTROL=ora.61034.798698.0.ctl LOG=ora.61034.798698.0.log BAD=ora.61034.798698.0.log.bad SILENT=header PARFILE=ora.61034...

Hi:

Got the following error while trying to compile my jobs.

Error calling subroutine: DSR_STATIC (Action=1);
check DataStage is set up correctly in project ASCAP_PROJ
(Subroutine failed to complete successfully (30107))

Please advise

Thanks

Hi All, Thanks for your reply Craig and Duke. This Shell Script initates a BCP load and then compares the file with the total record count and then those files are used in the next jobs. But here there is a problem, When I tried executing it TEST #1 ******* Arg1 = /PATH/tblFHASH Arg2 = /PATH/D_bcp.s...

Thanks Craig.. Here I am only confused when you try to concatenate the string with the arguments...so here should the script should take care to see that the agruments are passed to appropriate values in the script. This question may be basic this is the first time I am working with the Scripts. Yea...

Thanks for the reply,

We are trying to concatenate the string
of the Shell Path and Arguments, does the shell take care
of the path and the arguments to it, how does this work,
and also is the Screen Output name necessary like
what does that imply.

Hi All, I need to send parameters to UNIX shell scripting. The scripts goes with the name ds_load.sh with four parameters as arguments in it, like arg1, arg2, arg3 , agr4 . I see Call DSExecute command, but I am not sure as the exact format as to how to send parameters are passed. How can I send the...

Thanks for your reply.
Yes we will be reusing the same metadata. But I am wondering how do we actually do it. Is there any specific way that we can actually assig filename to a hash file, and target in between a job. And also curious as to how a source file could be dynamic names.

Thanks
Krishna

Hi All, Can we give dynamic filenames in between a job to hash files, source, and target. Here we have an ID coming in from the Source. How can we give this ID as a filename alongwith a static file name, for example #Key#_seg_name where #Key# is the dynamic number and _seg_name is static. Could anyo...