 |
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 15 matches |
| Author | Message |
|---|---|
 Topic: Trouble with DFSORT Web Site |
|
| Luc Orient Replies: 2 Views: 1587 |
 Forum: Utilities Posted: Sat Dec 12, 2009 7:09 am Subject: Trouble with DFSORT Web Site |
| Thank's / Merci Frank ... | |
| Topic: Trouble with DFSORT Web Site |
|
| Luc Orient Replies: 2 Views: 1587 |
Forum: Utilities Posted: Wed Dec 09, 2009 4:17 pm Subject: Trouble with DFSORT Web Site |
| I can't access to to the DFSORT Web Site when I use this URL :
http://www-947.ibm.com/systems/support/storage/software/sort/mvs/index.html It was OK a few weeks or months ago. Any change to the ... |
|
| Topic: Spliting a file like a COBOL OCCURS way |
|
| Luc Orient Replies: 6 Views: 2723 |
Forum: Utilities Posted: Mon Jul 28, 2008 1:37 pm Subject: Spliting a file like a COBOL OCCURS way |
| OK ... Thank's a lot ...
I will use a second pass with an OMIT statement ... Merci beaucoup pour vos r |
|
| Topic: Spliting a file like a COBOL OCCURS way |
|
| Luc Orient Replies: 6 Views: 2723 |
Forum: Utilities Posted: Sun Jul 27, 2008 3:12 pm Subject: Spliting a file like a COBOL OCCURS way |
| ... folowing :
Is it possible or should I use another step with a OMIT statement ? |
|
| Topic: Spliting a file like a COBOL OCCURS way |
|
| Luc Orient Replies: 6 Views: 2723 |
Forum: Utilities Posted: Sun Jul 27, 2008 3:09 pm Subject: Spliting a file like a COBOL OCCURS way |
| Well ... It's still me and I have a complementary question about my example ...
I want to eliminate the records with a zero value. I am talking about records after the reformat process. For in ... |
|
| Topic: Spliting a file like a COBOL OCCURS way |
|
| Luc Orient Replies: 6 Views: 2723 |
Forum: Utilities Posted: Mon Jul 21, 2008 4:34 pm Subject: Spliting a file like a COBOL OCCURS way |
| OK ... merci beaucoup ...
Il will try tomorow when I shall return to my office ... It's the night now in France ... |
|
| Topic: Spliting a file like a COBOL OCCURS way |
|
| Luc Orient Replies: 6 Views: 2723 |
Forum: Utilities Posted: Mon Jul 21, 2008 3:06 pm Subject: Spliting a file like a COBOL OCCURS way |
| Bonjour de Paris ...
I want to split a file as folows : Input file (in fact like a COBOL OCCURS file) : AA000100020003 BB000400050006 Output file : AA0001 AA0002 AA0003 BB0004 BB0005 ... |
|
| Topic: DFSORT/ICETOOL and Unicode ? |
|
| Luc Orient Replies: 1 Views: 1595 |
Forum: Utilities Posted: Sat Sep 22, 2007 6:13 am Subject: DFSORT/ICETOOL and Unicode ? |
| Can DFSORT/ICETOOL handle files coded in UNICODE ?
I can't find anything in the DFSORT documentation ... |
|
| Topic: performance tuning for sql query |
|
| Luc Orient Replies: 9 Views: 4797 |
Forum: Database Posted: Mon Aug 27, 2007 4:44 pm Subject: performance tuning for sql query |
| ... there are no indexes on any of the the tables ...
It's very strange ... even for PRIMARY_KEYS ? Is it possible to create index on your tables ? |
|
| Topic: performance tuning for sql query |
|
| Luc Orient Replies: 9 Views: 4797 |
Forum: Database Posted: Mon Aug 27, 2007 4:34 pm Subject: performance tuning for sql query |
| In general in a join of 2 or more tables, the columns that are to be joined must be indexed ...
Of course, it's a general idea ... As mentionned, it would be better to have the result of an EXPL ... |
|
| Topic: How to find the bad file from millons of records |
|
| Luc Orient Replies: 9 Views: 3941 |
Forum: Application Programming Posted: Mon Aug 27, 2007 12:45 pm Subject: How to find the bad file from millons of records |
| May be ICETOOL with the VERIFY operator ? | |
| Topic: SELECT FOR UPDATE and locks |
|
| Luc Orient Replies: 7 Views: 3307 |
Forum: Database Posted: Sat Aug 25, 2007 3:34 pm Subject: SELECT FOR UPDATE and locks |
| Luc,
If you are not going to UPDATE or DELETE anything why are you using the FOR UPDATE OF clause? Are you using the FOR UPDATE OF clause just to lock pages? What is the goal of your SQL? You ar ... |
|
| Topic: SELECT FOR UPDATE and locks |
|
| Luc Orient Replies: 7 Views: 3307 |
Forum: Database Posted: Sat Aug 25, 2007 1:51 pm Subject: SELECT FOR UPDATE and locks |
| Kolusu,
If there has been an 'UPDATE CURRENT CURSOR', will not a COMMIT or ROLLBACK be required to release any locks on updated rows/pages??? In my question there is no UPDATE ... WHERE CURRENT OF ... |
|
| Topic: SELECT FOR UPDATE and locks |
|
| Luc Orient Replies: 7 Views: 3307 |
Forum: Database Posted: Sat Aug 25, 2007 1:43 pm Subject: SELECT FOR UPDATE and locks |
| Luc Orient,
When you close a cursor with the CLOSE CURSOR statement that includes the WITH RELEASE clause, the database manager ... I am sorry but I don't see the WITH RELEASE clause in DB2 for ... |
|
| Topic: SELECT FOR UPDATE and locks |
|
| Luc Orient Replies: 7 Views: 3307 |
Forum: Database Posted: Sat Aug 25, 2007 9:14 am Subject: SELECT FOR UPDATE and locks |
| Hello :
A question about duration of a lock in a specific case : When I have a "SELECT FOR UPDATE" cursor and a package bound with ISOLATION(CS) "a row or page lock is held only lo ... |
|
All times are GMT - 5 Hours |