End Transaction - Need Help



Software AG's platform-independent programming language with full support for open-source and Internet applications

End Transaction - Need Help

Postby Arkantos » Tue May 11, 2010 6:24 pm

Need some help regarding the End Transaction statement.

1. Is there any limit in no of fields or limit in field size (Bytes) before issuing an end transaction command? (We have Natural 4.2 )

2. I have an adabas file which has almost 500+ fields in it and if i want to update all the fields in a program will there be any problem? I beleive Buffer size may be a prob. In that case can we increase the buffer size and what is the maximum buffer size?

3. Is there any way to get to know the buffer size without the help of ADA DBA?

Appreciate your help.

Cheers
Anbu
Arkantos
 
Posts: 18
Joined: Fri Apr 16, 2010 10:06 am
Has thanked: 0 time
Been thanked: 0 time

Re: End Transaction - Need Help

Postby RGZbrog » Wed May 12, 2010 1:43 pm

1. Is there any limit in no of fields or limit in field size (Bytes) before issuing an end transaction command?
An Adabas file can have up to 926 fields and you can update all of them. Between End Transaction (ET) commands you must not overflow the hold queue. Ask your DBA for the value of NISNHQ - the maximum number of records you can place on hold (that is, Store, Update, or Delete).

2. I have an adabas file which has almost 500+ fields in it and if i want to update all the fields in a program will there be any problem?
Are many of the fields long alphanumeric, and are they full? If all the fields are 1 or 2 bytes, no problem. If most are A250, but contain only 1 or 2 characters, no problem. If many fields are A50 and are filled with 50 non-blank characters, you may have a problem.

The compressed record must fit into a physical Adabas block. Basically the compressed record length is the sum of all field lengths without leading zeros and trailing blanks. The block size is selected by the DBA based on several criteria. You will need to ask.

3. Is there any way to get to know the buffer size without the help of ADA DBA?
Not really. During execution of your Natural program, you can see the compressed record length in DBLOG, but for the block size, take a look at an ADAREP (Adabas report) or ask a DBA.
User avatar
RGZbrog
 
Posts: 101
Joined: Mon Nov 23, 2009 1:34 pm
Location: California, USA
Has thanked: 0 time
Been thanked: 0 time

Re: End Transaction - Need Help

Postby Arkantos » Wed May 12, 2010 4:42 pm

Thanks a lot RGZbrog.

Cheers !
Arkantos
Arkantos
 
Posts: 18
Joined: Fri Apr 16, 2010 10:06 am
Has thanked: 0 time
Been thanked: 0 time

Re: End Transaction - Need Help

Postby RGZbrog » Wed May 12, 2010 7:45 pm

Oops. Forgot to mention that Adabas version 8 allows records to span blocks, so the record size limitation is eliminated.

Ralph
User avatar
RGZbrog
 
Posts: 101
Joined: Mon Nov 23, 2009 1:34 pm
Location: California, USA
Has thanked: 0 time
Been thanked: 0 time

Re: End Transaction - Need Help

Postby dick scherrer » Sat Sep 04, 2010 1:12 am

Hi Nic,

Hopefully, we'll not hear from "sam" any more. . .

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: End Transaction - Need Help

Postby NicC » Sat Sep 04, 2010 9:36 am

Hi Dick
Can you remove my posts relating to "Sam the Scam"?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: End Transaction - Need Help

Postby dick scherrer » Sat Sep 04, 2010 9:49 am

Hi Nic,

Going back a week, i see only this one (which is now gone<g>).

Let me know if there is something i missed,

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to Natural