Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SYSIBM.SYSDUMMY1

319 views
Skip to first unread message

pv

unread,
Nov 5, 2001, 3:14:32 PM11/5/01
to
I could not find SYSDUMMY1 table in AS/400 DB catalog.
We need it to migrate our application from OS/390. Is IBM planning to
get this to AS/400 or not ?

Thanks
peavy

Karl Hanson

unread,
Nov 5, 2001, 5:14:54 PM11/5/01
to
pv wrote:

This question has been asked in the past. The suggestion was to use
QSYS2.QSQPTABL

http://groups.google.com/groups?hl=en&selm=3A36EF55.248C6B5F%40vnet.ibm.com


Tim M

unread,
Nov 7, 2001, 12:36:11 AM11/7/01
to
I would not hold my breath waiting for this if I were you.

Try QSYS2.SYSPROCS or QSYS2.SYSTABLES

Why do you need a dummy table? Is this to enable you to write an Sql
statement to get the current date/time from the server?

"pv" <peav...@transamerica.com> wrote in message
news:479049d8.01110...@posting.google.com...

pv

unread,
Nov 7, 2001, 3:05:51 PM11/7/01
to
Thanks a bunch.

I am convinced that I should use QSYS2.QSQPTABL in place of SYSDUMMY1
from your kind responses and examples from IBM Iseries documents.

Here are some examples and uses (scalar functions ) with QSQTABL /
SYSDUMMY1 tables.

Example
Assume the following statement:

SELECT DIFFERENCE('CONSTRAINT','CONSTANT'),
SOUNDEX('CONSTRAINT'),
SOUNDEX('CONSTANT')
FROM QSYS2.QSQPTABL

Returns 4, C523, and C523. Since the two strings return the same
SOUNDEX value, the difference is 4 (the highest value possible).

Assume the following statement:

SELECT DIFFERENCE('CONSTRAINT','CONTRITE'),
SOUNDEX('CONSTRAINT'),
SOUNDEX('CONTRITE')
FROM QSYS2.QSQPTABL

0 new messages