PeopleCode - trying to write fields (from views) to file
edited Oct 20, 2014 3:19PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered ✓
I have fields in views - need to write to flat file. I have data in two levels - I need to write data to file from level 1 to the file, followed by level 2 data (related to level 1) to the same file, and repeat this process
Example:
Level 1 ................
Level 2............
Level 2............
Level 1 ................
Level 2............
Level 2............
I have tried writing directly from records, but code doesn't recognize field from view for level 1 that ties levels 1 and 2 together.
See code below:
While &SQLAmex0201.Fetch(&RecAmex0201)
&FldPymntNum = &RecAmex0201.GetField(Field.UNIQUE_ID);
In my log file, &FldPymntNum returns value of "Field" - instead of the value of
0