[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] Dynamic SQL?

I am not finding any documentation in the sqr server user guide for this
construct.  Can anyone clarify?

Begin-Procedure journal-id
    move 'PS_ITEM_ACTIVITY A, PS_CUSTOMER m, PS_ENTRY_TYPE_TBL B,
PS_JRNL_HEADER_FS Z1' to $from_tables
   If $PMBreakup = 'A'
        Let $from_tables = 'PS_ITEM_ACTIVITY A, PS_CUSTOMER m,
PS_ENTRY_TYPE_TBL B, PS_JRNL_HEADER_FS Z1,PS_CUST_PRD_INFO_L cp'
   end-if
    do build-journal-id-where-clause             
End-Procedure journal-id

This is the from clause used on the driving query.
FROM [PS_CUSTOMER m,PS_ENTRY_TYPE_TBL B,PS_ITEM_ACTIVITY A : $from_tables] 

 
Ivan C. Turner
Qwest Communications International, Inc.
703.363.4630

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users