Search found 7 matches

by cpando1974
Thu Mar 15, 2018 5:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job getting error message when try to open
Replies: 4
Views: 3552

Thanks, I have tried exporting and get same message

Failed to convert the object into its persistent form

Looks like it is corrupted.
by cpando1974
Thu Mar 15, 2018 3:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job getting error message when try to open
Replies: 4
Views: 3552

Parallel job getting error message when try to open

Morning A strange problem has occurred when trying to open a parallel job, I now get the following error; Unable to open the job Failed to convert the object into its persistent form Anyone else trying to open the parallel job gets the file is locked. Our DBA has looked into the problem and says not...
by cpando1974
Thu Oct 19, 2017 8:06 am
Forum: General
Topic: Difficulty with Nested Conditions using row count
Replies: 9
Views: 4742

Bingo! Thank you Craig. Thanks everyone for your help.
by cpando1974
Thu Oct 19, 2017 3:57 am
Forum: General
Topic: Difficulty with Nested Conditions using row count
Replies: 9
Views: 4742

A Parallel Job writing to a SeqFile holds the count of the rows from the error capturing table. Then an Execute Command calls the file by the location C:\PATH\FILENAME. This is where I am unsure, unclear whether a command is needed before file location? Searching on the web has drawn a blank so far ...
by cpando1974
Wed Oct 18, 2017 5:33 am
Forum: General
Topic: Difficulty with Nested Conditions using row count
Replies: 9
Views: 4742

I use a generic routine, invoked through a Routine activity, to determine whether there are any rows in a file or Data Set. The routine also has a "first line is column headings" flag. FUNCT ...[/quote] Thanks Ray, unfortunately I cannot see all of your reply due to the Premium notice. Ac...
by cpando1974
Tue Oct 17, 2017 8:59 am
Forum: General
Topic: Difficulty with Nested Conditions using row count
Replies: 9
Views: 4742

Thanks tanumoy2017. Getting a problem now where nothing is being read from the file. The file has the entry of 2 but being ignored by the conditions for diverting to the emails. Looking in the log the Output from command ====> is empty. Any ideas?

Thanks
by cpando1974
Wed Oct 11, 2017 4:24 am
Forum: General
Topic: Difficulty with Nested Conditions using row count
Replies: 9
Views: 4742

Difficulty with Nested Conditions using row count

Hello I am pretty new to DataStage and having a problem with Nested Conditions and row counts. Basically, I have an error table that records discrepancies and need them notifying to me. I have a Nested Condition that determines if there are no records in the table then send a Successful notification...