Hi all,
When I create a sequential dump of a table I get a file with extension ".S"
The first to lines contain the data
2008-10-02 15:30:22.218
#$!pre-dump!$#00037cv

I think the first line is about the date and time. Please correct if I am wrong. I dont know what does the second line means. Can anyone please tell about me it ??

Thanks in advance
--Rahul

Hi,

The first line is a timestamp and should comply to the format
"0000-00-00 00:00:00.000" (the character '0' stands for a digit).

The second line is a "magic" ("#$!pre-dump!$#") followed by the version number of the dump followed by the options that describe the dump.

- The version number is encoded as a 4 digit decimal number ("0001").

- The separator is encoded as a 2 digit hexadecimal number ("00").

- The last character 'v' stands for 'variable format', as opposed to 'f' which stands for 'fixed format' (-x option).

From:
http://www.baanboard.com/baanboard/showthread.php?t=59

You might want to check this link also:
http://www.baanboard.com/baanboard/showthread.php?t=30834

I hope it helps,

- George

Hi George,
Thanks a lot for your kind reply.

I still require more clarification for lines given below
#$!pre-dump!$#00037cv

If "#$!pre-dump!$#" is some magic number, how come it remains same for all the dump files.

From the previous reply:
Need some more clarification for lines quoted below

"0000-00-00 00:00:00.000" (the character '0' stands for a digit).
I understand that first "0000-00-00" is date, then "00:00:00" is time in hh:mm:ss format, but I am unable to understand the next three digits at the end.

- The version number is encoded as a 4 digit decimal number ("0001").
Will you PLEASE tell how the version number is encoded (means encoding logic) ?

- The last character 'v' stands for 'variable format', as opposed to 'f' which stands for 'fixed format' (-x option).
Will you PLEASE tell what is "variable format" and "fixed format" ?

Rahul,
I understand that first "0000-00-00" is date, then "00:00:00" is time in hh:mm:ss format, but I am unable to understand the next three digits at the end.
Refer to the link - sequential dump text (http://www.baanboard.com/baanboard/showthread.php?t=8855&highlight=bdbpre+options)
Will you PLEASE tell what is "variable format" and "fixed format" ?
Refer to the Tech manuals for more options/information on bdbpre binary and also the link - bdbpost synopsis (http://www.baanboard.com/baanboard/showthread.php?p=1809&highlight=synopsis#post1809)
Also be aware from the Porting Set 8.4 onwards the dump format has changed. Refer to the Porting Set's release notes:
Porting set 8.4a
Dump format changed
The internal dumpformat generated by bdbpre, via session ‘create sequential dump of tables’, is improved. Older porting sets will not be able to read this dump format.
Via the environment variable PREVERSION=3 or the resource preversion:3 it is possible to enforce dumping in the old format.
For example:
$ head tzmadm200100.S
2008-11-19 11:55:15.302
#$!pre-dump!$#00067cvyISO-8859-1
#$!languages!$#
##$!cdf!$#
Ubaantrn|UBaan Training|Ubaantrn|UHua.Fen|U+604639221|U|UMicrosoft Windows XP [Version 5.1.2600]|Uijl911732|Uxxx|U8.4a.01.7\\\\n|U2.4.17|U|U|0|U|10152008|30|Ubshell_lmssuser|UDev|US-[%h][%c][%S][%s][%f]|
Uapplic|UApplication_user|Uapplic|U|U|U|U|U|U|U|U|U|U|2|U|00000000|30|U|U|U|

What is your point of your question?
Will you PLEASE tell how the version number is encoded (means encoding logic) ?
Is it for academic purposes? Baan does not have to disclose the encoding format to customers.

Hi NPRao,
Thanks a lot for your reply.

Refer to the Porting Set's release notes
Can you please tell from where will I get the information about Porting Set's release notes.

$ head tzmadm200100.S
2008-11-19 11:55:15.302
#$!pre-dump!$#00067cvyISO-8859-1
#$!languages!$#
##$!cdf!$#
Ubaantrn|UBaan Training|Ubaantrn|UHua.Fen|U+604639221|U|UMicrosoft Windows XP [Version 5.1.2600]|Uijl911732|Uxxx|U8.4a.01.7\\\\n|U2.4.17|U|U|0|U|10152008|30|Ubshell_lmssuser|UDev|US-[%h][%c][%S][%s][%f]|
Uapplic|UApplication_user|Uapplic|U|U|U|U|U|U|U|U|U|U|2|U|00000000|30|U|U|U|

I am unable to understand your given example. It looks like a dump file. If so then is the header height variable, means the dump file I am able to create using the standard session "ttaad4226m000" just have 2 lines of header.
If the height is variable, then while reading the dump file how will be I able to differentiate between the actual data and the header.

Is it for academic purposes?
No I am not asking the question for academic purpose. I have the requirement where I have to read the given dump file and create the new dump file with some modifications.

Hi NPRao,

I am able to understand the format of timestamp of the dump file"2008-11-19 11:55:15.302" but what is the last 3 digit "302". Is it milisecond, If so do we have any function from where i can get even the time upto milisecond in Baan.

Thanks