Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] data migrator
 Login/Join
 
Gold member
posted
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
 
Posts: 85 | Registered: February 27, 2009Reply With QuoteReport This Post
Gold member
posted Hide Post
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
 
Posts: 85 | Registered: February 27, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.