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

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     proper syntax for executing a MSS stored procedure
Go
New
Search
Notify
Tools
Reply
  
proper syntax for executing a MSS stored procedure
 Login/Join
 
Member
posted
lOOKING FOR PROPER SYNTAX FOR EXECUTING A MSS STORED PROCEDURE
Using Webfocus 5.3.2, here is my syntax. Unfortunately all I get is a " (FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
: ERROR: ncjInit failed
L (FOC1405) SQL PREPARE ERROR"

ANY HELP OR SUGGESTIONS WOULD BE APPRECIATED

-MRNOEDIT BEGIN
SET SQLENGINE = SQLMSS
SQL SQLMSS SET USER TMPSQL01/USER_ID,PASSWORD
SQL SQLMSS

SQL
EX trac_WO.dbo.lblsp_get_partno_by_workorder;
END
 
Posts: 1 | Registered: May 06, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
Try:

SQL SQLMSS SET USER TMPSQL01/USER_ID,PASSWORD
SQL SQLMSS EX trac_WO.dbo.lblsp_get_partno_by_workorder
END

You may also want to look at:
iWay Adapter Administration for UNIX, Windows,
OpenVMS, OS/400, OS/390, and z/OS
Version 7 Release 1.3
DN9400230.0206


ttfn, kp


Access to most releases from R52x, on multiple platforms.
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Reply With QuoteReport This Post
Member
posted Hide Post
You first have to make sure you queue up the remote connection to the SQL server properly, i.e. a hub-sub configuration. Try this example:
-MRNOEDIT BEGIN
REMOTE DEST = WFSA2003
-REMOTE BEGIN
SQL SQLMSS SET SERVER TMPSQL01
SQL SQLMSS
EX Trac_WO.dbo.lblsp_get_partno_by_workorder 'W36389';
TABLE FILE SQLOUT
PRINT *
ON TABLE PCHOLD AS LISTOFWO
END
-REMOTE END
-MRNOEDIT END
TABLE FILE LISTOFWO
PRINT *
END


Robert B. Clark -- Business Systems Analyst
Daimler Trucks North America
Phone: 503.745.7057
"There's always a better way."
IBM Mainframe zOS 8.1.05, DB2 adapter
WF 8.1.05 Hub to Sub, Self-Service, SQL Server adapter
 
Posts: 25 | Location: Portland, OR | Registered: October 13, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     proper syntax for executing a MSS stored procedure

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