I am not sure if this is a matter of personal preference, but which hold file output type would be the best in the following situation?
I am joining Table 1 with Table 2 on Course_id. Then the final output file to the customer will be an xml file. Although I know I could just Table File Table2, get the fields I want and use a BY HIGHEST 1 ACADEMIC_PERIOD, I am just using this as an example for learning/demonstration purposes. I am trying to decide if I should hold Table 1 as ALPHA, FOCUS, or something else so I can join it to Table 2.FieldsTable 1
Course_Id A255V <-- Unique ValuesTable 2
Course_Credit D20.2Example Data TableTable 1
Table 1 contains a master list of course_id, all unique, max 1000 records.Table 2
|ENGL200 001|English |American Lit|Long Text |3.0 |201110 |
|CSCI101A101|Comp Sci |MS Word Lab |Long Text |0.5 |201110 |
|WRIT101 001|Writing |Writing 1 |Long Text |3.0 |201180 |
|ENGL201 001|English |Euro Lit |Long Text |3.0 |201180 |
|ENGL201 001|English |Euro Lit |Long Text |4.0 |201210 |
Table 2 contains 10000+ records with duplicate course_id but different academic semesters, course_desc, course_title, and about 50 other fields.
Edit: Forum messed up formatting, not surprised in the least bit, but I tried to fix it the best I could.
Developer Studio 7.7.02
Windows XP Pro SP3 and Windows 7 64bit