DSXchange

Thank You for Your help.

ArndW wrote:Use the checksum function and then examine the output character field. Do you think that can be converted to an integer or bigint?

I did and the output is alphanumeric and it looks like 'a78hfbge98'. I dont think this can be converted to integer

Learn patience. I typically don't respond to posts at 4am my time. DSXchange is an all-volunteer site whose members post as and when they can. If you need one hour response, sign up with your official support provider for priority service (and good luck finding one who'll agree to a one hour SLA!) ...

Does anyone have answer for this....

Can CheckSum Stage generate the checksum field in integer/Bigint ? If yes, Can you please explain me how.

Your question is whether an insertion failure caused by referential integrity should fail the job or flow down the reject link. Yes Thats Exactly My Question Set your array size and commit size to 1, I have seen behavior where having a large array/commit size resulted in a job failing instead of re...

ArndW wrote:Please have your DBA check the foreign key FQA551.

I just checked with my DBA and there are no triggers on any of the table with foreign key FQA551.

Check in your database whether there are any triggers for this child table pointing to parent table. Can you be specific about which triggers. I just asked my DBA what she told me is they just employed Foreign Key and Primary key relationships between parent and child tables, other than that they d...

Hi, I created One Dataset with one record with PolicyNumber as Key Column and I am trying to insert it into a DB2 table using ODBC Enterprise Stage with a reject link going to a sequential File Stage. Well the Table to which I am inserting is a Child Table to a Parent table having same PolicyNumber ...

It worked Thanks Chulet and Anbu.... :D :D

The job is getting failed throwing me these errors Seq_Load_TQC05_POLICY..JobControl (@Execute_Command_43): Executed: printf $(<D:\DataFiles\ETL_DEV_MaxSurrKeyFiles\TQC05_POLICY_Max_SRC_SYS_ID.txt) Reply=1 Output from command ====> The system cannot find the file specified. Seq_Load_TQC05_POLICY..Jo...

Thanks for your reply anbu I am using Cat filename.txt to read a integer value in text file into a job parameter for the next job activity stage. For date datatype the solution you told above is working fine. For integer how to delete that new line char? Do we need to use anything other that Cat for...

The return value is actually a dynamic array, so one other solution would be to take just the first element from it: ExecuteCmd.$CommandOutput<1> Another would be to strip the Field Mark that is added to the return value: Convert(@FM,"",ExecuteCmd.$CommandOutput) Both of those solutions w...