1. Forum
  2. Usenet
  3. COMP.SYS.TANDEM

  • SQL - Enscribe File

    From Adam Kamal@21:1/5 to s4n...@gmail.com on Wed Feb 17 11:01:48 2021
    On Tuesday, October 20, 2020 at 9:24:28 AM UTC-7, s4n...@gmail.com wrote:
    On Monday, October 19, 2020 at 7:02:03 PM UTC+8, DerekW wrote:
    On Friday, 20 December 2019 at 04:10:46 UTC+2, s4n...@gmail.com wrote:
    On Friday, December 20, 2019 at 5:09:26 AM UTC+8, Chandy wrote:
    Hi Andre ,

    That's sound interesting , Definately I would like to try this.

    Best regards
    Chandan
    HI Chandan,

    Please send to above email. So I can reply to your's email.

    Regards,
    Andre A
    That's sound interesting , Definitely I would like to try this.

    Reards,
    Derek
    Hi Chandan and Derek,

    Please check your email.

    Thanks.

    Can I get access to this tool too? Thanks in advance!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From ssrinath22@gmail.com@21:1/5 to s4n...@gmail.com on Mon Mar 1 09:08:55 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From uros kusar@21:1/5 to All on Wed Jun 16 04:06:14 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dan Kjeldsen@21:1/5 to All on Fri Sep 16 01:53:17 2022
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Rob Walker@21:1/5 to All on Tue Sep 20 00:24:52 2022
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)