ObjType *TBL ?

Michael Schwarze

unread,

Dec 19, 1997, 3:00:00 AM12/19/97

to

Who knows something about OS/400 Tables ?
What does they do and how could I create one ?
Examples ?

Thanks,

Michael Schwarze

OSITim

unread,

Dec 20, 1997, 3:00:00 AM12/20/97

to

Tables(*TBL objects) serve several functions on the AS/400. They can be used
for character translation:

ASCII -> EBCDIC use the QEBCDIC table
EBCDIC -> ASCII use the QASCII table

to traslate lower case to upper case use QSYTRNTBL(sp?)

You can also use them in DDS for database files to specify an alternate
collating sequence ie. an alternate ordering of characters. (See recent issue
of News/400 for an interesting application of this for Y2K).

Use the CRTTBL, WRKTBL, DLTTBL commands. Translate tables can be created from
source records, or from an interactive panel.

Ronald G"oggel

unread,

Dec 20, 1997, 3:00:00 AM12/20/97

to

Michael Schwarze schrieb in Nachricht <67el6s$bj3$1...@news01.btx.dtag.de>...

>Who knows something about OS/400 Tables ?
>What does they do and how could I create one ?

They can be used to replace characters by other characters.
for example to convert lowercase to uppercase
or if you want to replace all vocals by blanks ...

*TBL are created by Selection of "14" in PDM or CRTTBL (?)
Check GO CMDTBL for further commands

*TBL are used by a API-Programm named QDCXLATE.

>Examples ?

AFAIK there are some examples in a CL-book (but I don't remember which one)

In the API-Reference there is a description of the Parameters

>
>Thanks,
>
>Michael Schwarze

HTH

Ronald

Paul Valentine

unread,

Dec 20, 1997, 3:00:00 AM12/20/97

to

I have used tables for the Alternate Collating Sequence for database files.
I can be used to change the order in which records are retrieved. Typically,
this is ascending or descending (A, B, C or C,B,A), but if you specify a
table, you can retrieve records in a sequence or A,C,B or whatever you like.
When you create the table you specify some table source. This is eight lines
of 16 hex values in the order you wish to retrieve you data.

Paul.

Michael Schwarze wrote in message <67el6s$bj3$1...@news01.btx.dtag.de>...

>Who knows something about OS/400 Tables ?
>What does they do and how could I create one ?

Paul Valentine

unread,

Dec 20, 1997, 3:00:00 AM12/20/97

to

This is an example of one...

Attractive isn't it.

A0A1A2A3A4A5A6A7A8A9AAABACADAEAFF0F1F2F3F4F5F6F7F8F9BABBBCBDBEBF
000102030405060708090A0B0C0D0E0F101112131415161718191A1B1C1D1E1F
202122232425262728292A2B2C2D2E2F303132333435363738393A3B3C3D3E3F
404142434445464748494A4B4C4D4E4F505152535455565758595A5B5C5D5E5F
606162636465666768696A6B6C6D6E6F707172737475767778797A7B7C7D7E7F
808182838485868788898A8B8C8D8E8F909192939495969798999A9B9C9D9E9F
C0C1C2C3C4C5C6C7C8C9CACBCCCDCECFD0D1D2D3D4D5D6D7D8D9DADBDCDDDEDF
E0E1E2E3E4E5E6E7E8E9EAEBECEDEEEFB0B1B2B3B4B5B6B7B8B9FAFBFCFDFEFF

Paul Valentine wrote in message <67h94o$h2e$1...@ultra.sonic.net>...

Michael Schwarze

unread,

Dec 21, 1997, 3:00:00 AM12/21/97

to

First many thanks or ALL the help,

but there's now another question :

I need a table to convert a file from a unkown system, located on a PC,
which have some garbage-characters above ASCII-Code 128,
The example is only 8 lines with 16 hex-chars = 128 characters.
Are more table-entries allowed ?

OSITim

unread,

Dec 22, 1997, 3:00:00 AM12/22/97

to

All 256 characters are supported. To use an interactive screen to create a
table instead of a source member type the following command.

CRTTBL TBL(MYLIB/MYTABLE) SRCFILE(*PROMPT)

you can optionally specify BASETBL(xxxxx) if you want your new table to be
based an an existing table (ie. QASCII, QEBCDIC, etc...)