× Discuss on porting data from legacy systems to T24. Data mapping, Data Migration tool, Extract Statergy, Writing runbook, Cut-over, Migrate static and Financial data, Balance transfer, Technical and Functional reconciliation, etc…

R17/18 Oracle database structure

  • carlos
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
5 years 9 months ago #21882 by carlos
R17/18 Oracle database structure was created by carlos
Hi All,

With new R17/18 version of T24, has the table structure (Ex: In Oracle DB) changed from the basic 2 column structure (ID + XML in BLOB field) to a RDBMS structure?

Thanking you in advance for any help!

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
More
5 years 9 months ago #21884 by VK
Replied by VK on topic R17/18 Oracle database structure
Hi
no it's not
SELECT * FROM F_SPF =
SYSTEM
<row xml:space="preserve" id="SYSTEM"><c1>20180426</c1><c2>Model Bank</c2><c3>O</c3><c5>../bnk.data</c5><c8>R18</c8><c9>1</c9><c11>0</c11><c12>200</c12
><c14>TAPE</c14><c15>Y</c15><c16>N</c16><c17>5</c17><c19>../bnk.data</c19><c20>../bnk.run</c20><c21>../bnk.dict</c21><c23>NT</c23><c24>./backup.hd &amp
;M&amp;</c24><c25>./restore.hd &amp;M&amp;</c25><c27>5</c27><c28>999</c28><c30>201803</c30><c32>10</c32><c35>BEF</c35><c35 m="2">ESP</c35><c35 m="3">IT
L</c35><c35 m="4">JPY</c35><c35 m="5">PTE</c35><c35 m="6">XAU</c35><c35 m="7">KWD</c35><c35 m="8">XAG</c35><c36>APASGTMNS000</c36><c37>20181031</c37><c
39>AA</c39><c39 m="2">AB</c39><c39 m="3">AC</c39><c39 m="4">AD</c39><c39 m="5">AG</c39><c39 m="6">AI</c39><c39 m="7">AL</c39><c39 m="8">AM</c39><c39 m=
"9">AO</c39><c39 m="10">AP</c39><c39 m="11">AR</c39><c39 m="12">AU</c39><c39 m="13">AX</c39><c39 m="14">BE</c39><c39 m="15">BL</c39><c39 m="16">BM</c39
><c39 m="17">BN</c39><c39 m="18">BP</c39><c39 m="19">BR</c39><c39 m="20">BX</c39><c39 m="21">BZ</c39><c39 m="22">CA</c39><c39 m="23">CD</c39><c39 m="24
">CE</c39><c39 m="25">CK</c39><c39 m="26">CL</c39><c39 m="27">CM</c39><c39 m="28">CO</c39><c39 m="29">CP</c39><c39 m="30">CR</c39><c39 m="31">CS</c39><
c39 m="32">CX</c39><c39 m="33">CZ</c39><c39 m="34">DA</c39><c39 m="35">DC</c39><c39 m="36">DD</c39><c39 m="37">DE</c39><c39 m="38">DF</c39><c39 m="39">
DI</c39><c39 m="40">DL</c39><c39 m="41">DM</c39><c39 m="42">DP</c39><c39 m="43">DS</c39><c39 m="44">DW</c39><c39 m="45">DX</c39><c39 m="46">DZ</c39><c3
9 m="47">EB</c39><c39 m="48">EC</c39><c39 m="49">ED</c39><c39 m="50">EF</c39><c39 m="51">EP</c39><c39 m="52">ET</c39><c39 m="53">EU</c39><c39 m="54">EV
</c39><c39 m="55">EW</c39><c39 m="56">FA</c39><c39 m="57">FD</c39><c39 m="58">FE</c39><c39 m="59">FI</c39><c39 m="60">FR</c39><c39 m="61">FT</c39><c39
m="62">FW</c39><c39 m="63">FX</c39><c39 m="64">GP</c39><c39 m="65">GR</c39><c39 m="66">I9</c39><c39 m="67">IA</c39><c39 m="68">IB</c39><c39 m="69">IC</
c39><c39 m="70">ID</c39><c39 m="71">IF</c39><c39 m="72">IH</c39><c39 m="73">II</c39><c39 m="74">IM</c39><c39 m="75">IN</c39><c39 m="76">IS</c39><c39 m=
"77">IX</c39><c39 m="78">JP</c39><c39 m="79">LC</c39><c39 m="80">LD</c39><c39 m="81">LI</c39><c39 m="82">LM</c39><c39 m="83">MC</c39><c39 m="84">MD</c3
9><c39 m="85">MF</c39><c39 m="86">MM</c39><c39 m="87">MO</c39><c39 m="88">MS</c39><c39 m="89">MT</c39><c39 m="90">MX</c39><c39 m="91">NA</c39><c39 m="9
2">NR</c39><c39 m="93">NS</c39><c39 m="94">OA</c39><c39 m="95">OC</c39><c39 m="96">OF</c39><c39 m="97">OO</c39><c39 m="98">OP</c39><c39 m="99">OQ</c39>
<c39 m="100">OS</c39><c39 m="101">OV</c39><c39 m="102">PC</c39><c39 m="103">PD</c39><c39 m="104">PH</c39><c39 m="105">PI</c39><c39 m="106">PM</c39><c39
 m="107">PO</c39><c39 m="108">PP</c39><c39 m="109">PPACHC</c39><c39 m="110">PPBACS</c39><c39 m="111">PPCHAT</c39><c39 m="112">PPFATF</c39><c39 m="113">
PPFEDW</c39><c39 m="114">PPHKGC</c39><c39 m="115">PPIEBA</c39><c39 m="116">PPINST</c39><c39 m="117">PPISOX</c39><c39 m="118">PPPSDC</c39><c39 m="119">P
PSPCT</c39><c39 m="120">PPSPDD</c39><c39 m="121">PPSTAL</c39><c39 m="122">PPTGTC</c39><c39 m="123">PR</c39><c39 m="124">PT</c39><c39 m="125">PV</c39><c
39 m="126">PW</c39><c39 m="127">PX</c39><c39 m="128">PZ</c39><c39 m="129">RA</c39><c39 m="130">RC</c39><c39 m="131">RE</c39><c39 m="132">RP</c39><c39 m
="133">RR</c39><c39 m="134">RS</c39><c39 m="135">RW</c39><c39 m="136">SA</c39><c39 m="137">SB</c39><c39 m="138">SC</c39><c39 m="139">SD</c39><c39 m="14
0">SE</c39><c39 m="141">SF</c39><c39 m="142">SG</c39><c39 m="143">SL</c39><c39 m="144">SP</c39><c39 m="145">ST</c39><c39 m="146">SW</c39><c39 m="147">S
Y</c39><c39 m="148">T1</c39><c39 m="149">T2</c39><c39 m="150">T3</c39><c39 m="151">T4</c39><c39 m="152">T5</c39><c39 m="153">TI</c39><c39 m="154">TK</c
39><c39 m="155">TT</c39><c39 m="156">TX</c39><c39 m="157">TY</c39><c39 m="158">VL</c39><c39 m="159">VP</c39><c39 m="160">VS</c39><c39 m="161">WD</c39><
c39 m="162">WR</c39><c39 m="163">WS</c39><c39 m="164">XF</c39><c39 m="165">XP</c39><c39 m="166">XT</c39><c41>Y</c41><c42>N</c42><c43>500</c43><c49>1</c
49><c64>YES</c64><c92>2</c92><c93>1166_INPUTTER</c93><c94>1711271053</c94><c95>5725_AUTHORISER</c95><c96>GB0010001</c96><c97>1</c97><c103>5</c103><c104
>14144_INPUTTER</c104><c105>1804301926</c105><c106>14144_INPUTTER</c106><c107>GB0010001</c107><c108>1</c108></row>

Cheers
VK
The following user(s) said Thank You: carlos

Please Log in or Create an account to join the conversation.

Time to create page: 0.068 seconds