The format of the file name produced for a MEMO type field when exported using swutil EXTCD.

The format of the file name produced for a MEMO type field when exported using swutil EXTCD.

book

Article ID: KB0085449

calendar_today

Updated On:

Products Versions
TIBCO iProcess Engine (SQL) -
TIBCO iProcess Engine (Oracle) -
Not Applicable -

Description

Resolution:
The file name is constructed internally as follows:

The format of the file name created by swutil is “+mRRRRRRAAA.MMM”.

RRRRRR = Case num, AAA = array index, MMM = memo ID

The calculated rule of the case number, array id and memo id is the same and uses base 50.

The 49 numbers used in the base 50 system are :-

    0123456789abcdefghijklmnopqrstuvwxyz' #$%&-_@(){}'~

Examples:

    50 = 0010
    49 = 000~
    60 = 001a
       
Table of Numeric number versus Base 50 Numbers:

Number    Base 50 No    Number    Base 50 No     Number    base 50 No
10                 a               20                  k                30                  u
11                 b               21                  l                 31                  v
12                 c               22                  m               32                  w
13                 d               23                  n                33                  x
14                 e               24                  o                34                  y
15                 f                25                  p                35                  z
16                 g               26                  q                36                  '
17                 h               27                  r                 37                  #
18                 i                28                  s                38                  $
19                 j                29                  t                 39                  %

Number    Base 50 No   
40                    &       
41                     -       
42                     _       
43                    @       
44                     (       
45                     )       
46                     {       
47                     }       
48                     '       
49                     ~       


For example, if the case number is 2751 the memo file name for the Memo field with Memo ID 1 will be +m000151000.001

number of 50 X 50 X 50 X 50 X 50    = 0    Therefore number = 0
number of 50 X 50 X 50 X 50            = 0    Therefore number = 0
number of 50 X 50 X 50                    = 0    Therefore number = 0
number of 50 X 50 's                         = 1    Therefore number = (1 X 50 X 50) = 2500
number of 50's                                 = #    Therefore number = (5 X 50)      =       250
number of unit's                                = 1    Therefore number                       =          1

Total number in Base 10 = 2751

The memo identifier number (Memo ID), can be obtained from using the 'plist' utility with the -f switch
 i.e.,    plist -f <procname>

This gives a typical listing as below:

Offset    Name               typ    Len    DP/MID     Marks      Flags       Dbase
0          $PANICDIR          A      B          0            0          0000h
10        $PANICFLD          A      15         0           0           0000h
27        $PANICRSP          A      1          0           0           0000h
30        MEMO01              F       0          1           0           0000h

Issue/Introduction

The format of the file name produced for a MEMO type field when exported using swutil EXTCD.