MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 203 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Listing of dataset names with wildcards
CZerfas

Replies: 2
Views: 3330

PostForum: Utilities   Posted: Tue Jan 16, 2018 2:14 am   Subject: Listing of dataset names with wildcards
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 ...
  Topic: Listing of dataset names with wildcards
CZerfas

Replies: 2
Views: 3330

PostForum: Utilities   Posted: Mon Jan 15, 2018 6:45 am   Subject: Listing of dataset names with wildcards
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 ...
  Topic: Read a sequential file with SQL
CZerfas

Replies: 2
Views: 1984

PostForum: Application Programming   Posted: Mon Nov 28, 2016 9:57 am   Subject: Read a sequential file with SQL
SQL is the front-end to work with the contents of DB2 databases. You cannot read sequential files with SQL.

regards
Christian
  Topic: Link to LOOKAT is not working
CZerfas

Replies: 5
Views: 5498

PostForum: About Mvsforums   Posted: Fri Jul 08, 2016 1:12 am   Subject: Link to LOOKAT is not working
Hello Kolosu,

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

Kind regards
Christian
  Topic: Link to LOOKAT is not working
CZerfas

Replies: 5
Views: 5498

PostForum: About Mvsforums   Posted: Thu Jul 07, 2016 8:49 am   Subject: Link to LOOKAT is not working
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 ...
  Topic: DB2 unload , reformat and load
CZerfas

Replies: 8
Views: 4609

PostForum: Database   Posted: Fri Aug 28, 2015 6:25 am   Subject: DB2 unload , reformat and load
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 ...
  Topic: Dynamically changing accessed DB2 tables
CZerfas

Replies: 2
Views: 2562

PostForum: Database   Posted: Thu Apr 12, 2012 3:05 am   Subject: Dynamically changing accessed DB2 tables
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 ...
  Topic: SQL Cursor in PL1
CZerfas

Replies: 7
Views: 6234

PostForum: Application Programming   Posted: Thu Feb 09, 2012 9:18 am   Subject: SQL Cursor in PL1
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 ...
  Topic: DSNH902I
CZerfas

Replies: 5
Views: 2865

PostForum: Database   Posted: Fri Aug 12, 2011 3:08 am   Subject: DSNH902I
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 ...
  Topic: Help needed on creating Update query
CZerfas

Replies: 4
Views: 2878

PostForum: Database   Posted: Mon Jul 18, 2011 3:05 am   Subject: Help needed on creating Update query
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 ...
  Topic: Acessing part of a BLOB column
CZerfas

Replies: 4
Views: 3022

PostForum: Database   Posted: Fri May 20, 2011 8:10 am   Subject: Acessing part of a BLOB column
I think that hex values are not DECIMAL. Try CHARACTER instead.

regards
Christian
  Topic: Package authority from SySIBM tables
CZerfas

Replies: 9
Views: 4562

PostForum: Database   Posted: Fri May 06, 2011 4:10 am   Subject: Package authority from SySIBM tables
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 ...
  Topic: Regarding Retrofit
CZerfas

Replies: 8
Views: 5836

PostForum: TSO and ISPF   Posted: Tue Jan 11, 2011 4:06 am   Subject: Regarding Retrofit
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 ...
  Topic: Binding a program to 2 differnt subsystems
CZerfas

Replies: 10
Views: 4328

PostForum: Database   Posted: Tue Jan 11, 2011 4:02 am   Subject: Binding a program to 2 differnt subsystems
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 ...
  Topic: Regarding Retrofit
CZerfas

Replies: 8
Views: 5836

PostForum: TSO and ISPF   Posted: Mon Jan 10, 2011 10:12 am   Subject: Regarding Retrofit
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 ...
 
Page 1 of 14 Goto page 1, 2, 3 ... 12, 13, 14  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group