 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 5 matches |
| Author | Message |
|---|---|
 Topic: DB2 timestamp question |
|
| Rajeev_jha Replies: 6 Views: 8882 |
 Forum: Database Posted: Sun Jan 05, 2003 11:42 pm Subject: DB2 timestamp question |
| Once you get the precompile time from the catalog table(SYSIBM.SYSDBRM) try to find out the compile time from your load module. There can be any one of the following reasons
1) your load library n ... |
|
| Topic: Validate every byte in a field |
|
| Rajeev_jha Replies: 23 Views: 14742 |
Forum: Application Programming Posted: Fri Dec 20, 2002 6:13 am Subject: Validate every byte in a field |
| Dibakar,
I have a module that checks for all the valid characters in the keyboard or else replaces it by spaces. This was developed as our file was transmitted from mainframe to UNIX. Any any junk ... |
|
| Topic: Counting no: of records in a file |
|
| Rajeev_jha Replies: 12 Views: 37909 |
Forum: Utilities Posted: Fri Dec 20, 2002 6:02 am Subject: Counting no: of records in a file |
| If you have SAS in your installation you can do it with SAS also. Using the SAS you can define which fields it has to count and print report also | |
| Topic: Accessing tables in different DB2 sub-systems |
|
| Rajeev_jha Replies: 12 Views: 15971 |
Forum: Database Posted: Fri Dec 20, 2002 4:52 am Subject: Accessing tables in different DB2 sub-systems |
| Yes you can do this. You need to know the location names for the tables. Suppose TABLE A exits is the location TISDB2P and TABLEB exists in TISDB2N then you can refer to the tables as
TISDB2P.owne ... |
|
| Topic: DB2 timestamp question |
|
| Rajeev_jha Replies: 6 Views: 8882 |
Forum: Database Posted: Fri Dec 20, 2002 4:46 am Subject: DB2 timestamp question |
| In case you do not have Platinum you can find it using SPUFI. Execute the following query
SELECT * FROM SYSIBM.SYSPLAN WHERE NAME = 'plan name'; SELECT * FROM SYSIBM.SYSDBRM WHERE PLNAME = 'plan ... |
|
All times are GMT - 5 Hours |