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     [SOLVED] Can we HOLD FORMAT SQLPSTGR to a temporary file? (Yes, we can)
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Can we HOLD FORMAT SQLPSTGR to a temporary file? (Yes, we can)
 Login/Join
 
Virtuoso
posted
As topic.

We tried:
TABLE FILE CAR
PRINT CAR
BY COUNTRY
WHERE RECORDLIMIT EQ 1;
ON TABLE HOLD AS #CAR FORMAT SQLPSTGR
END

That unfortunately throws an error:

 0 NUMBER OF RECORDS IN TABLE=        0  LINES=      0
 0 NUMBER OF RECORDS IN TABLE=        1  LINES=      1
 (FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) XOPEN: 42601
 :  (0) [42601] ERROR: syntax error at or near "#"
  Position: 15
 (FOC1414) EXECUTE IMMEDIATE ERROR.


The ON TABLE HOLD statement does a DROP/CREATE table, so creating the temporary table beforehand doesn't look like a workaround either...

Is there a trick to this? Am I missing something (obvious)?

This message has been edited. Last edited by: Wep5622,


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1633 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Does it work if you don't have the AS #CAR?


WebFOCUS 8204, Unix, Windows
 
Posts: 1527 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
No, that creates a permanent table named HOLD in the default schema (public).

But! I found that the solution is actually rather simple; just write the table to the pg_temp schema:
TABLE FILE CAR
PRINT CAR
BY COUNTRY
WHERE RECORDLIMIT EQ 1;
ON TABLE HOLD AS pg_temp.CAR FORMAT SQLPSTGR
END


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1633 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Can we HOLD FORMAT SQLPSTGR to a temporary file? (Yes, we can)

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