As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
SQL SQLMSS SET SERVER &CONNECTION SQL SQLMSS EX wftest.dbo.store ProcedureDropDown; TABLE FILE SQLOUT PRINT * ON TABLE HOLD AS test1 END TABLE FILE test1 PRINT down1 NOPRINT COMPUTE CARRNM/A100 = ''; ON TABLE HOLD AS test2 FORMAT ALPHA END -RUN
SQL SQLMSS SET SERVER &CONNECTION SQLMSS EX wftest.dbo.otherProced ; TABLE FILE SQLOUT PRINT * ON TABLE HOLD AS XSQLOUT END -RUN
the elaborated messgae fo FOC36232 states: "Each !IBI escape sequence must be terminated by a semi-colon." Perhaps you can start with concatenating a semi-colon to the end of each row in "test2", that just may do the trick for you...
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005