IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

S2K DATABASE HELP REQUIRED


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
smiley
Warnings : 1

New User


Joined: 08 Feb 2006
Posts: 27

PostPosted: Wed Sep 12, 2012 1:50 am
Reply with quote

We are using S2K DATABASE in our application. We were trying to insert tree in to the S2K DATABASE. But not able to do the same. if anyone can help on the syntax and the basic commands for S2K
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Wed Sep 12, 2012 1:55 am
Reply with quote

I believe that SYSTEM 2000 is a product of SAS. If you have a license for it, either read the fine (proprietary) manuals or inquire of SAS.
Back to top
View user's profile Send private message
smiley
Warnings : 1

New User


Joined: 08 Feb 2006
Posts: 27

PostPosted: Wed Sep 12, 2012 4:04 pm
Reply with quote

Yes, Its an SAS product. We recently took this from another vendor. But unfortunately we didnt get any manuals shared for this.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Wed Sep 12, 2012 4:26 pm
Reply with quote

Google is your friend. Googling system 2000 commands returns over 16 million hits, and on the very first page is a link to the Getting Started with S2K manual from SAS. And chapter 4 in that manual talks about the INSERT TREE command and its syntax.

If your site has a license for S2K, then you can get the manuals from SAS. Unless it has changed a lot since I last used it, S2K is a hierarchical data base not a relational data base. Hence the command syntax tends to be different since it was around before SQL.
Back to top
View user's profile Send private message
smiley
Warnings : 1

New User


Joined: 08 Feb 2006
Posts: 27

PostPosted: Wed Sep 12, 2012 7:27 pm
Reply with quote

we have tried the same based on this manual but we are not able to establish a connection between the parent and child record. they are as standalone record
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Wed Sep 12, 2012 7:31 pm
Reply with quote

Have you talked to SAS Institute yet?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts What database does Jobtrac use CA Products 4
No new posts Capturing COBOL job and program names... All Other Mainframe Topics 2
No new posts Products/Tools to Optimize Adabas Dat... Compuware & Other Tools 2
No new posts AUTHORIZED database error in HALDB IMS DB/DC 2
No new posts linking an ALC program to a Relationa... PL/I & Assembler 1
Search our Forums:

Back to Top