what does SQL, DDS mean in Generation mode?

5 pts.
Tags:
Synon
SYNON COOL2E
what does SQL, DDS mean in Generation mode in an Access path in SYNON

Software/Hardware used:
SYNON COOL2E

Answer Wiki

Thanks. We'll let you know when a new response is added.

I would assume it means you are using SQL to create a table(file), and theSQL instructions are in a source member. (Probably QDDSSRC).
The table is created with a RUNSQLSTM
Something like this for the source member:
<pre>
CREATE TABLE SPDLVCTL
(Credit_Union_Number for CUNO CHAR (04) Not Null with Default,
Delivery_Type for DLVTYPE CHAR (03) Not Null with Default,
Server_Name for SERVER CHAR (10) Not Null with Default,
Delivery_Folder for FOLDER CHAR (256) Not Null with Default,
File_Extension for FILEXT CHAR (10) Not Null with Default,
File_Type for FILETYP CHAR (06) Not Null with Default,
Path_Rpt_Date for PATHDAT CHAR (01) Not Null with Default,
Path_Rpt_Constant for PATHCNST CHAR (01) Not Null with Default,
Path_Rpt_Name for PATHRNAME CHAR (01) Not Null with Default,
Start_Date for STRDATE DATE Not Null with Default,
End_Date for ENDDATE DATE Not Null with Default,
Change_Date for CHGDATE DATE Not Null with Default,
Change_USer for CHGUSER CHAR (10) Not Null with Default,
TMG_Sequence_Number for TMGSEQ INT Not Null
generated always as identity (Start with 1 increment by 1))
RCDFMT SPDLVCTLR;</pre>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following