Focal Point
[SOLVED] data migrator

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/1917083076

April 29, 2014, 10:20 AM
ray_In_Vancouver
[SOLVED] data migrator
This Query is running perfect but I need to capture a return param from it and use it in the whole flow.

the param name is @AwiFileID


SQL SQLMSS SET SERVER WMS_Live
SQL SQLMSS SET ERRORTYPE DBMS
SQL SQLMSS


ex wms.dbo.spAWIFile 1
END
-IF &RETCODE NE 0 GOTO BADRUN;
-EXIT
-BADRUN
-TYPE put message text here
-EXIT



this is the current return

04/29/2014 07:20:16 LOOPBACK FILE=@@@@0025 ,SUFFIX=FIX
04/29/2014 07:20:16 LOOPBACK SEGNAME=@@@@0025,SEGTYPE=S0
04/29/2014 07:20:16 LOOPBACK FIELDNAME =AwiFileID ,E01 ,I11 ,A11 ,
04/29/2014 07:20:16 LOOPBACK MISSING=ON, $

This message has been edited. Last edited by: <Kathryn Henning>,


IWay SM 5.6, 6.01, 6.1, 6.9, 7.0
EDI, XML, XSD, WF 8.0, DM 77,8.0 asp.net, SQL Server
April 29, 2014, 01:13 PM
ray_In_Vancouver
The Answer is this, thanks to tech support


SQL SQLMSS SET SERVER WMS_Live
SQL SQLMSS SET ERRORTYPE DBMS
SQL SQLMSS

ex wms.dbo.spAWIFile 1;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS TOUT
END
-RUN
-DEFAULT &AwiFileID = ' '
-READFILE TOUT
-SET &&AWIFILEID = &AwiFileID;

-EXIT
-IF &RETCODE NE 0 GOTO BADRUN;
-EXIT
-BADRUN
-TYPE &&AwiFileID
-EXIT


IWay SM 5.6, 6.01, 6.1, 6.9, 7.0
EDI, XML, XSD, WF 8.0, DM 77,8.0 asp.net, SQL Server