DSXchange

Hi, I'm loading cust_key column value with bigint datatype to db2 database.but NULL values are getting load into the table.while i tried to load the same cust_key column to dataset,values are getting loaded correct. Not knowing why the NULL values are getting loaded into the db2 database. Could any ...

Hi, Can any please let me know how to convert string to integer datatype.I know that Datastage implicitly convert the string datatype tp integer datatype without any external function but i'm not getting accurate data in the output. For example: I have cust_key(varchar(40) as input and its value 300...

Hi All, I have job design as: Dataset---->modify------>DB2 table where i have used update statment. When i run the job individually means,it is completing successfully but when i run the job in sequence means it is aborting giving the error:db2CS_ORDER_FACT: ERROR during execution of DB2-CLI request...

Sainath.Srinivasan wrote:Space or blank is not a decimal value. Use a number

Yes,now i used Handle_Null(order_nbr,0) and it is working fine.

Thanks for your timely response.

Regards,
Kalpana.

Hi All, I'm having input column order_nbr(decimal9,0) nullable but while loading this to target i'm handling null values by using modify stage function as Handle_Null(order_nbr,"").But is giving error message as "Bad literal for type decimal: ." Please let me know what is wrong i...

Hi All, I have job design as below: dataset------>cpy----->DB2 in dataset i have two columns,one is order_nbr(decimal(9,0) and nullable value is "no".The other one is order_key(integer(10) and nullable is yes.The job ran successfully but getting warning as "When checking operator: Whe...

rohithmuthyala wrote:Clearing the partition in the copy/dataset stage should solve this problem.

Yes,the above solution worked.Thanks for your timely response...

Thanks & Regards,
Kalpana

Hi All, I have job design as below: Dataset------->cpy-------->DB2(write method:Upsert and autogenerated update only and DB2 partitioning) Job is ran successfully ,but getting warning message as"When checking operator: Operator of type "APT_Db2UpsertOperator": will partition despite t...

Is "session_key" declared in the dataset and passed into the stage? Did you declare "session_key" in the DB2 stage columns and then not use it in your insert or update statements? no session_key is not present in the dataset,infact dataset is having only two columns that are ord...

Hi All, I have the job design as : dataset----->DB2 dataset with two columns ORDER_NBR(decimal 9,0) and order_key(integer 10) DB2 stage is having other columns as sesion_key,update_time,ORDER_NBR(decimal 9,0),order_key(integer 10). I'm using write method:upsert and upsert method is Auto-generatedupd...

That's about 1600 rows per second. The bottleneck is almost certainly the "writing" stage. But you need to establish the timings of each - the select with and without the functions, writing to a tex ... As I'm not premier member,I'm not able to view the full answer of yours.Ray could you ...

Hi, My job design is like: DB2---------->Modify----------->DB2 I have 5,925,155 records in source, an I am doing direct load into target using write/append option. In modify I'm using NOWARN specification. Other than this I'm not doing any kind of conversion. In source I'm converting decimal to char...

mhester wrote:Sounds to me like the processes cannot be started on the remote server. How many nodes in your DPF server are defined in your config and can you ssh or rsh between all of the servers and it is keyless (no password needed)?

Can you please tell me how to do this ssh or ssh?

Hi , I'm facing issue in running datastage job.Actually my job design looks like as below: DB2 UDB Enterprise stage----->Modify stage------->DB2 UDB Enterprise stage When I tried executing this job I got the below error: " Service table transmission failed for db2node1 (uhqq3cadm01-p:Broken pip...

Replace the target DB2 stage with a Peek stage temporarily and determine what values are being selected. You don't seem to have a "." between the schema name and the table name. ... No actually I'm passing the schema name with "." as paramter.I think I'm facing table space issue...