From Newsgroup: comp.sys.tandem

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
--- Synchronet 3.21d-Linux NewsLink 1.2

From Newsgroup: comp.sys.tandem

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
--- Synchronet 3.21d-Linux NewsLink 1.2