Search found 6 matches

by maryann
Thu Mar 16, 2006 9:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run jobs from command line
Replies: 15
Views: 8650

All the parameters can be stored in a file and BASIC can be used to just read the file and pass the parameter to the job/sequence as required. And if you are requested(If need to trigger only from command prompt after scheduling), you can call this Batch Job (Which has the BASIC code which calls th...
by maryann
Fri Oct 28, 2005 10:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with OR logic in constraint
Replies: 7
Views: 2430

Maryann, can you modify your job to see which part of the OR isn't working as expected? My suspicion is that the (ENDOFDATA IS FALSE) part isn't doing it - but it is unfounded and I don't have a 390 to try out. well (ENDOFDATA IS FALSE AND FIELD1 > ' ') was original condition to start with which wa...
by maryann
Fri Oct 28, 2005 8:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with OR logic in constraint
Replies: 7
Views: 2430

I tried all sorts like: (field2 = 'N' OR field1 > " ") AND (ENDOFDATA IS FALSE) ((field2 = 'N') OR (field1 > " ")) AND (ENDOFDATA IS FALSE) and vice versa Nothing seems to work. If it matters, field1 is normalized variable of OCCURS clause and field2 also sets its value based on ...
by maryann
Thu Oct 27, 2005 6:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with OR logic in constraint
Replies: 7
Views: 2430

In the comparison for field1, is the constant on the right hand side two characters long (that is, compliant with PIC X(2))? That is, are you comparing field1 against a string containing two space characters. Clutching at straws a little here. Can you also try surrounding the second expression with...
by maryann
Thu Oct 27, 2005 5:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with OR logic in constraint
Replies: 7
Views: 2430

Welcome aboard! :D Are field1 and field2 columns from an upstream stage, stage variables, or what? What is the data type of field1? How does it get its value assigned? Are you confident that field2 is being calculated correctly? Have you checked - perhaps by dumping a copy of the input stream into ...
by maryann
Thu Oct 27, 2005 4:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with OR logic in constraint
Replies: 7
Views: 2430

Problem with OR logic in constraint

This is in mainframe job. My constraint reads something like this: (field1 > ' ' OR field2 ='N') AND ENDOFDATA IS FALSE field2 is stage variable checks for a numeric field value and sets 'Y' if it is spaces or lowvalues or zero else 'N'. Problem: when field1 is put to spaces or low values , even if ...