MVSFORUMS.com

Hello Kolusu,

thank you for your answer. Pitty, I just looked at ENTRIES with listcat. Now I have datasets with additional qualifiers in the resulting list, but I can filter those out with the codi ...

I need to create a list of cataloged datasets in batch with a search-mask using wildcards as in the ADRDSSU-DUMP syntax, e.g.
QUALI1.QUALI2.*.D%%%%%%.T%%%%%%

I tried IDCAMS listcat, but that ...

SQL is the front-end to work with the contents of DB2 databases. You cannot read sequential files with SQL.

regards
Christian

Hello Kolosu,

thank you very much. Though not necessary up to date, LOOKAT is always a good source for informations.

Kind regards
Christian

On the entry Panel to mvsforums.com is a link to the LOOKAT facility (under "Messages and Error Codes") to translate System Messages. This link currently points to some obscure IBM Panel, bu ...

If there are too many rows to be inserted, you could "unload" your source table with a SELECT making all the needed reformats running under DSNTIAUL and, with a propper load statement, load ...

If you are relative new to DB2, look at the concept of packages and collections. What you want to achieve, switching between test databases, is done best with binding the dbrms into multiple collectio ...

Since the coding you want to change is part of an EXEC SQL statement, you can only perform this by using dynamic SQL. Within static SQL, as you are using it, this isn't possible.

regards
Chris ...

The CCSID used by the DB2 precompiler is burried in the parameters used, either set during the customization of the precompiler or explicitly by your invocation of the precompiler.

If you want to u ...

The main problem with the update statement is, that you don't have a FROM clause where you could list more than one table.

That means, that in case of the need of accessing more than one table, you ...

I think that hex values are not DECIMAL. Try CHARACTER instead.

regards
Christian

To retrieve the sorts of SQL statements a package is issuing against a table, use this query:
SELECT *
FROM SYSIBM.SYSTABAUTH
WHERE COLLID = 'your collection of the pa ...

Yes, there is a separately lincensed feature called "parallel development facility" or PDF, where you can code a commmand file that controls the merge process of these two versions.

We do ...

Concerning your question of binding: You have to BIND your program only against 1 DB2 subsystem. Within this subsystem, you have to implement the possibility for your program to access the table in th ...

For Windows operating systems there are a lot of merge tools that give you the options you are looking for. In our shop we use "beyond compare" very successfully. The prerequisit for it's us ...