Dictionary to SQL

[Deskin, Bob]

And if anyone cares, QSHOW on MPE/iX does the same, generating a file
named QSHOSQL. And yes, it generates a table for each dataset in an
IMAGE database.

Bob

-----Original Message-----
From: Deskin, Bob 
Sent: February 7, 2005 4:28 PM
To: 'Joe Boyle'; 'Johnson, Harold A EDUC:EX'; 'Goparaju, Vidyasagar'
Cc: 'PowerHouse List'
Subject: RE: Dictionary to SQL


Well, this doesn't happen every day. This is a new one on me as well.
I've tried it in 8.40D on OpenVMS and 8.41D on Windows. I'll make a bold
assumption that UNIX works like Windows. On OpenVMS, the file created is
named QSHOSQL.TXT. On UNIX and Windows the file is named qshogen.sql.
The general syntax is

SET LANG SQL
GENERATE DATABASE <file>

where <file> is any file (relational or not). All records under the file
have SQL generated for them. I tried it with a direct file and an
indexed file.

Thanks Sagar

Bob

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Joe Boyle
Sent: February 7, 2005 1:56 PM
To: 'Johnson, Harold A EDUC:EX'; 'Goparaju, Vidyasagar'
Cc: 'PowerHouse List'
Subject: RE: Dictionary to SQL


I am astonished and delighted. I must have specified a database name
when running the command in the past

Thanks and regards, Joe.


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Johnson, Harold A
EDUC:EX
Sent: 07 February 2005 18:39
To: Goparaju, Vidyasagar
Cc: PowerHouse List
Subject: RE: Dictionary to SQL

Indeed, that was it.  I tried it under 830d and it works like a charm!
 
thnx and cheers
 
-----Original Message----- 
From: Goparaju, Vidyasagar [mailto:VGoparaju@tradepointsystems.com] 
Sent: Fri 2/4/2005 2:36 PM 
To: Johnson, Harold A EDUC:EX 
Cc: PowerHouse List 
Subject: RE: Dictionary to SQL


We are on PowerHouse 8.10.C2. 
 
It could be due to the Powerhouse version that you are running.
 
Sagar
 
 
 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber. 
  
       This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.