Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

I use technology in order to hate it more properly. -- Nam June Paik

computers / comp.sys.tandem / Re: SQL - Enscribe File

SubjectAuthor
* Re: SQL - Enscribe Fileuros kusar
`* Re: SQL - Enscribe FileDan Kjeldsen
 `- Re: SQL - Enscribe FileRob Walker

1
Re: SQL - Enscribe File

<c5265d02-e1b1-48df-b485-01837eeaaefen@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/computers/article-flat.php?id=184&group=comp.sys.tandem#184

  copy link   Newsgroups: comp.sys.tandem
X-Received: by 2002:a05:620a:21c3:: with SMTP id h3mr4801393qka.202.1623841575066;
Wed, 16 Jun 2021 04:06:15 -0700 (PDT)
X-Received: by 2002:a25:bbd0:: with SMTP id c16mr5463303ybk.138.1623841574849;
Wed, 16 Jun 2021 04:06:14 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Wed, 16 Jun 2021 04:06:14 -0700 (PDT)
In-Reply-To: <f1ee8d13-fc0a-4ee0-8b1b-ae33b7361e44n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=91.208.168.48; posting-account=dNxdAgoAAADbf7oqjm6wK0FgVxfPvmuX
NNTP-Posting-Host: 91.208.168.48
References: <f59b6f36-42b4-4f44-b28c-cecc51236a4a@googlegroups.com> <f1ee8d13-fc0a-4ee0-8b1b-ae33b7361e44n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <c5265d02-e1b1-48df-b485-01837eeaaefen@googlegroups.com>
Subject: Re: SQL - Enscribe File
From: uros.kusar@gmail.com (uros kusar)
Injection-Date: Wed, 16 Jun 2021 11:06:15 +0000
Content-Type: text/plain; charset="UTF-8"
 by: uros kusar - Wed, 16 Jun 2021 11:06 UTC

ponedeljek, 01. marec 2021 ob 18:08:56 UTC+1 je oseba ssrin...@gmail.com napisala:
> On Tuesday, December 17, 2019 at 9:16:55 AM UTC-5, s4n...@gmail.com wrote:
> > Hi Guys,
> >
> > Currently I have a tool to query Enscribe file using SQL command.
> > If you interested to try, just let me know.
> >
> > ----------------------------------------------------------------------------
> > Enscribe Query 2.0 (Beta) (Non-Commercial Version)
> > *** Developed by Andre Ardiayanto (s4n...@gmail.com) ***
> > >>help
> > Help is available for the following commands :
> >
> > HEADING Command
> > DEFAULT IS ON
> > Example : HEADING ON
> > : HEADING OFF
> > RAWDATA Command
> > DEFAULT IS OFF
> > Example : RAWDATA ON
> > : RAWDATA OFF
> > CLEAR Command
> > DICT Command
> > Example : DICT $TEST.ADRTOOL
> > HELP Command
> > OUT or OUTPUT Command
> > Example : OUT TERM (PRINT TO TERMINAL)
> > : OUT $VOL.SUBVOL.FILENAME ! (WILL PURGE THE PREVIOUS DATA)
> > : OUT $VOL.SUBVOL.FILENAME (CONTINUE TO WRITE TO NEXT RECORD)
> > SEPARATOR Command
> > Example : SEPARATOR ,
> > SHOW Command
> > How To use : SHOW {RECS|DEFS} RECORD-NAME/DEFINITION-NAME, {TAL|COBOL}
> > : SHOW {RECS|DEFS} *
> > : SHOW {*}
> > Example : SHOW RECS *
> > : SHOW RECS ATDD1, TAL
> > : SHOW DEFS *
> > : SHOW DEFS ATDD1
> > : SHOW *
> > FUNCTIONS List
> > : UNPAK^BINARY or BIN^HEXCHAR^BINARY
> > : HEX^ASC^BINARY
> > : UNPAK or BIN^HEXCHAR
> > : HEX^ASC
> > : BINARY
> > : SUM
> > SELECT Command
> > Example : SELECT * FROM [TABLE] WHERE [CONDITION]
> > : SELECT [FIELD^NAME, ...] FROM [TABLE] WHERE [CONDITION] [LIMIT 1]
> > [SKIP 1]
> > : SELECT [FIELD^NAME, ...] FROM [=DEFINE^NAME] WHERE [CONDITION]
> > : SELECT * FROM $VOl.SUBVOL.FILENAME WHERE TERM-ID = "%TEST%" AND
> > AMT-1 > 700 LIMIT 50
> > : SELECT BINARY(TERM-ID) FROM $VOl.SUBVOL.FILENAME WHERE TERM-ID = "%T
> > EST%" AND AMT-1 > 700 LIMIT 50
> > : SELECT BINARY(TERM-ID[0:0]) FROM $VOl.SUBVOL.FILENAME WHERE TERM-ID
> > = "%TEST%" AND AMT-1 > 700 LIMIT 50
> > SET Command
> > Example : SET RECS TLF
> > : SET DEFS TLF
> > UPDATE Command (Coming Soon)
> > INSERT Command (Coming Soon)
> >
> > HOW TO USE
> > 1. YOU MUST SET THE DICT LOCATION USING DICT COMMAND
> > 2. IF THE FILENAME SAME AS RECORD NAME, NO NEED TO SET RECS/DEFS
> > ELSE YOU NEED TO SET RECS/DEFS USING SET COMMAND
> > 3. IF YOU WANT THE OUTPUT IN FILE YOU SHOULD USING OUT or OUTPUT COMMAND
> > 4. IF YOU DONT WANT TO PRINT THE HEADER/HEADING YOU SHOULD USING HEADING COMMAND
> > >>exit
> > $TEST ADRTOOL 3> z
> Hi Andre, How to access this tools ? I am interested to try out.
>
> thanks
Hi Andre,

I'm very interested, can I try this tool to?

Regards,
Uros

Re: SQL - Enscribe File

<d932e530-4a3b-4af0-9dfb-0bd8e6dc38d1n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/computers/article-flat.php?id=548&group=comp.sys.tandem#548

  copy link   Newsgroups: comp.sys.tandem
X-Received: by 2002:ac8:5a8e:0:b0:344:69b2:1307 with SMTP id c14-20020ac85a8e000000b0034469b21307mr3329918qtc.57.1663318398446;
Fri, 16 Sep 2022 01:53:18 -0700 (PDT)
X-Received: by 2002:a25:e74f:0:b0:6ae:eaef:36cb with SMTP id
e76-20020a25e74f000000b006aeeaef36cbmr3609228ybh.199.1663318398076; Fri, 16
Sep 2022 01:53:18 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Fri, 16 Sep 2022 01:53:17 -0700 (PDT)
In-Reply-To: <c5265d02-e1b1-48df-b485-01837eeaaefen@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=185.108.254.25; posting-account=4xxbCwoAAABAzWACxwBe5w2xs9veNgLc
NNTP-Posting-Host: 185.108.254.25
References: <f59b6f36-42b4-4f44-b28c-cecc51236a4a@googlegroups.com>
<f1ee8d13-fc0a-4ee0-8b1b-ae33b7361e44n@googlegroups.com> <c5265d02-e1b1-48df-b485-01837eeaaefen@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <d932e530-4a3b-4af0-9dfb-0bd8e6dc38d1n@googlegroups.com>
Subject: Re: SQL - Enscribe File
From: dankj1970@gmail.com (Dan Kjeldsen)
Injection-Date: Fri, 16 Sep 2022 08:53:18 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 4337
 by: Dan Kjeldsen - Fri, 16 Sep 2022 08:53 UTC

onsdag den 16. juni 2021 kl. 13.06.15 UTC+2 skrev uros kusar:
> ponedeljek, 01. marec 2021 ob 18:08:56 UTC+1 je oseba ssrin...@gmail.com napisala:
> > On Tuesday, December 17, 2019 at 9:16:55 AM UTC-5, s4n...@gmail.com wrote:
> > > Hi Guys,
> > >
> > > Currently I have a tool to query Enscribe file using SQL command.
> > > If you interested to try, just let me know.
> > >
> > > ----------------------------------------------------------------------------
> > > Enscribe Query 2.0 (Beta) (Non-Commercial Version)
> > > *** Developed by Andre Ardiayanto (s4n...@gmail.com) ***
> > > >>help
> > > Help is available for the following commands :
> > >
> > > HEADING Command
> > > DEFAULT IS ON
> > > Example : HEADING ON
> > > : HEADING OFF
> > > RAWDATA Command
> > > DEFAULT IS OFF
> > > Example : RAWDATA ON
> > > : RAWDATA OFF
> > > CLEAR Command
> > > DICT Command
> > > Example : DICT $TEST.ADRTOOL
> > > HELP Command
> > > OUT or OUTPUT Command
> > > Example : OUT TERM (PRINT TO TERMINAL)
> > > : OUT $VOL.SUBVOL.FILENAME ! (WILL PURGE THE PREVIOUS DATA)
> > > : OUT $VOL.SUBVOL.FILENAME (CONTINUE TO WRITE TO NEXT RECORD)
> > > SEPARATOR Command
> > > Example : SEPARATOR ,
> > > SHOW Command
> > > How To use : SHOW {RECS|DEFS} RECORD-NAME/DEFINITION-NAME, {TAL|COBOL}
> > > : SHOW {RECS|DEFS} *
> > > : SHOW {*}
> > > Example : SHOW RECS *
> > > : SHOW RECS ATDD1, TAL
> > > : SHOW DEFS *
> > > : SHOW DEFS ATDD1
> > > : SHOW *
> > > FUNCTIONS List
> > > : UNPAK^BINARY or BIN^HEXCHAR^BINARY
> > > : HEX^ASC^BINARY
> > > : UNPAK or BIN^HEXCHAR
> > > : HEX^ASC
> > > : BINARY
> > > : SUM
> > > SELECT Command
> > > Example : SELECT * FROM [TABLE] WHERE [CONDITION]
> > > : SELECT [FIELD^NAME, ...] FROM [TABLE] WHERE [CONDITION] [LIMIT 1]
> > > [SKIP 1]
> > > : SELECT [FIELD^NAME, ...] FROM [=DEFINE^NAME] WHERE [CONDITION]
> > > : SELECT * FROM $VOl.SUBVOL.FILENAME WHERE TERM-ID = "%TEST%" AND
> > > AMT-1 > 700 LIMIT 50
> > > : SELECT BINARY(TERM-ID) FROM $VOl.SUBVOL.FILENAME WHERE TERM-ID = "%T
> > > EST%" AND AMT-1 > 700 LIMIT 50
> > > : SELECT BINARY(TERM-ID[0:0]) FROM $VOl.SUBVOL.FILENAME WHERE TERM-ID
> > > = "%TEST%" AND AMT-1 > 700 LIMIT 50
> > > SET Command
> > > Example : SET RECS TLF
> > > : SET DEFS TLF
> > > UPDATE Command (Coming Soon)
> > > INSERT Command (Coming Soon)
> > >
> > > HOW TO USE
> > > 1. YOU MUST SET THE DICT LOCATION USING DICT COMMAND
> > > 2. IF THE FILENAME SAME AS RECORD NAME, NO NEED TO SET RECS/DEFS
> > > ELSE YOU NEED TO SET RECS/DEFS USING SET COMMAND
> > > 3. IF YOU WANT THE OUTPUT IN FILE YOU SHOULD USING OUT or OUTPUT COMMAND
> > > 4. IF YOU DONT WANT TO PRINT THE HEADER/HEADING YOU SHOULD USING HEADING COMMAND
> > > >>exit
> > > $TEST ADRTOOL 3> z
> > Hi Andre, How to access this tools ? I am interested to try out.
> >
> > thanks
> Hi Andre,
>
> I'm very interested, can I try this tool to?
>
> Regards,
> Uros
Hi Andre

I would like to try this tool as well.

Regards
Dan

Re: SQL - Enscribe File

<5a802f66-0301-4cd5-8209-dfbe2ee9e313n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/computers/article-flat.php?id=549&group=comp.sys.tandem#549

  copy link   Newsgroups: comp.sys.tandem
X-Received: by 2002:a05:622a:311:b0:35c:fb41:69d6 with SMTP id q17-20020a05622a031100b0035cfb4169d6mr583623qtw.337.1663658693258;
Tue, 20 Sep 2022 00:24:53 -0700 (PDT)
X-Received: by 2002:a25:4045:0:b0:6ae:b15a:cd81 with SMTP id
n66-20020a254045000000b006aeb15acd81mr17788172yba.340.1663658692976; Tue, 20
Sep 2022 00:24:52 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Tue, 20 Sep 2022 00:24:52 -0700 (PDT)
In-Reply-To: <d932e530-4a3b-4af0-9dfb-0bd8e6dc38d1n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=88.97.5.22; posting-account=VNCh7AoAAACrZx-4uZR7AuNAFO2WZSZh
NNTP-Posting-Host: 88.97.5.22
References: <f59b6f36-42b4-4f44-b28c-cecc51236a4a@googlegroups.com>
<f1ee8d13-fc0a-4ee0-8b1b-ae33b7361e44n@googlegroups.com> <c5265d02-e1b1-48df-b485-01837eeaaefen@googlegroups.com>
<d932e530-4a3b-4af0-9dfb-0bd8e6dc38d1n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <5a802f66-0301-4cd5-8209-dfbe2ee9e313n@googlegroups.com>
Subject: Re: SQL - Enscribe File
From: piste.shredder@googlemail.com (Rob Walker)
Injection-Date: Tue, 20 Sep 2022 07:24:53 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1637
 by: Rob Walker - Tue, 20 Sep 2022 07:24 UTC

Just an FYI - the firm I work for released an official (aka commercial product) in this space for those needing a supported product with advanced features:

https://testing.ascert.com/news/ascert-expands-relate-product-family-to-offer-direct-sql-and-jdbc-access

There's contact details at bottom of PR for anyone wanting more info.

-Rob

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor