Re: journalling question

["Al Barsa, Jr." <barsa2@xxxxxxx>]

At 11:39 AM 8/12/99 +0200, you wrote:


>Hi everybody
>
>I have created a file using DDS.
>By default  the DSPFFD of that file say s  'journelled as NO'
>I want to make the journelled 'YES'
>How?
>
>Hint:
>If I create table by sql, and the if I give DSPFFD for this table(created by
>sql)
>it says 'journelled YES'
>
>Since I have lot of tables created through DDS, I need some quick solution to
>make it
>as 'journelled YES'


First of all, I hope the command that you are referring to is DSPFD, not 
DSPFFD.

Secondly, when you create a "data base" using SQL, what you actually create 
is a library containing a journal and journal receiver!

When you create an SQL "table", what you actually create is a non-keyed 
physical file in that library.  Assuming that the journal and receiver are 
still there (you can delete them if you don't want journaling), the 
physical file (a/k/a table) is automatically journaled.

If you want to journal any other file, you can use the STRJRNPF 
command.  This requires an exclusive lock on the physical file object.

I hope this answers your question.

Al




+--------------------------------------------------+
| Please do not send private mail to this address. |
| Private mail should go to barsa@ibm.net.         |
+--------------------------------------------------+

Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:          914-251-1234
Fax:            914-251-9406
http://www.barsaconsulting.com
http://www.taatool.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---