You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by sa...@apache.org on 2017/03/28 15:19:02 UTC
[2/6] incubator-trafodion git commit: Support for insert-select from
varchar/char colummns into lob columns. Supposed for insert with
parameter.This work is done as part of [TRAFODION-2516]
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d3d707ae/core/sql/regress/executor/EXPECTED130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED130 b/core/sql/regress/executor/EXPECTED130
index 9c8fb51..ef2e9d6 100644
--- a/core/sql/regress/executor/EXPECTED130
+++ b/core/sql/regress/executor/EXPECTED130
@@ -19,6 +19,17 @@
+>c2 char(10), c3 clob, primary key (c1));
--- SQL operation complete.
+>>create table t130char(c1 int not null, c2 char (20), primary key (c1));
+
+--- SQL operation complete.
+>>create table t130var(c1 int not null, c2 varchar(100), primary key (c1));
+
+--- SQL operation complete.
+>>create external table date_dim
++> (d_date_sk int, d_date_id varchar(100 bytes) character set utf8, d_date date)
++> for hive.hive.date_dim;
+
+--- SQL operation complete.
>>
>>?section dml_insert
>>insert into t130lob1 values(NULL);
@@ -52,9 +63,9 @@ C1
C1 C2
----------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------
- 1 LOBH0000000200010559696826186435416219559696826195743244718212351957479965039020"TRAFODION"."LOB130"
- 2 LOBH0000000200010559696826186435416219559696826196364100518212351957487711692020"TRAFODION"."LOB130"
- 3 LOBH0000000200010559696826186435416219559696826196975611918212351957493829420020"TRAFODION"."LOB130"
+ 1 LOBH0000000200010219168903258874722819219168903288954731118212356996658039353020"TRAFODION"."LOB130"
+ 2 LOBH0000000200010219168903258874722819219168903289672426518212356996666148698020"TRAFODION"."LOB130"
+ 3 LOBH0000000200010219168903258874722819219168903290319695818212356996672743207020"TRAFODION"."LOB130"
--- 3 row(s) selected.
>>
@@ -90,6 +101,92 @@ C1 (EXPR)
--- 3 row(s) selected.
>>
+>>delete from t130lob2;
+
+--- 3 row(s) deleted.
+>>--test insert with param (assumes that caller will pass in string format.)
+>>prepare s from insert into t130lob2 values (1, ?);
+
+--- SQL command prepared.
+>>execute s using 'fgfgfhfhfhfhhfhfhfhjfkkfkffllflflfll';
+
+--- 1 row(s) inserted.
+>>select lobtostring(c2,50) from t130lob2;
+
+(EXPR)
+--------------------------------------------------
+
+fgfgfhfhfhfhhfhfhfhjfkkfkffllflflfll
+
+--- 1 row(s) selected.
+>>
+>>--test insert select from a source char column to lob
+>>delete from t130lob2;
+
+--- 1 row(s) deleted.
+>>insert into t130char values (1,'fixed char 1'),(2,'fixed char 2'),(3,'fixed char 3');
+
+--- 3 row(s) inserted.
+>>insert into t130lob2(c1,c2) select c1,c2 from t130char;
+
+--- 3 row(s) inserted.
+>>select lobtostring(c2,50) from t130lob2;
+
+(EXPR)
+--------------------------------------------------
+
+fixed char 1
+fixed char 2
+fixed char 3
+
+--- 3 row(s) selected.
+>>
+>>--test insert select from a source varchar column to lob
+>>delete from t130lob2;
+
+--- 3 row(s) deleted.
+>>insert into t130var values (1,'var char 1'),(2,'var char 22222222222222222222222'),(3,'var char 33333333333333333333333333333333333333333333333333333');
+
+--- 3 row(s) inserted.
+>>insert into t130lob2(c1,c2) select c1,c2 from t130var;
+
+--- 3 row(s) inserted.
+>>select lobtostring(c2,100) from t130lob2;
+
+(EXPR)
+----------------------------------------------------------------------------------------------------
+
+var char 1
+var char 22222222222222222222222
+var char 33333333333333333333333333333333333333333333333333333
+
+--- 3 row(s) selected.
+>>
+>>--test insert select from a source hive varchar column to lob
+>>delete from t130lob2;
+
+--- 3 row(s) deleted.
+>>insert into t130lob2 select [first 10] d_date_sk,d_date_id from hive.hive.date_dim;
+
+--- 10 row(s) inserted.
+>>select lobtostring(c2,40) from t130lob2;
+
+(EXPR)
+----------------------------------------
+
+AAAAAAAAOKJNECAA
+AAAAAAAAPKJNECAA
+AAAAAAAAALJNECAA
+AAAAAAAABLJNECAA
+AAAAAAAACLJNECAA
+AAAAAAAADLJNECAA
+AAAAAAAAELJNECAA
+AAAAAAAAFLJNECAA
+AAAAAAAAGLJNECAA
+AAAAAAAAHLJNECAA
+
+--- 10 row(s) selected.
+>>
>>--test values clause
>>values((select * from t130lob1));
@@ -103,7 +200,7 @@ C1
>>--test empty_blob(), empty_clob()
>>delete from t130lob2;
---- 3 row(s) deleted.
+--- 10 row(s) deleted.
>>insert into t130lob2 values (1, empty_blob());
--- 1 row(s) inserted.
@@ -477,7 +574,7 @@ And the dish ran away with the fork !
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_txt1.txt');/g" >> t130_extract_command;
>>
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200010559696826186439964319559696826241512955218212351957939199849020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
+>>extract lobtofile(LOB 'LOBH0000000200010219168903258881619119219168903356455897718212356997334190246020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
Success. Targetfile :tlob130_txt1.txt Length : 19
--- SQL operation complete.
@@ -493,7 +590,7 @@ Success. Targetfile :tlob130_txt1.txt Length : 19
>>sh rm t130_extract_command;
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_deep.jpg');/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200010559696826186440101919559696826248930896218212351958013356713020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
+>>extract lobtofile(LOB 'LOBH0000000200010219168903258881727719219168903363726830218212356997406948130020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
Success. Targetfile :tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -509,7 +606,7 @@ Success. Targetfile :tlob130_deep.jpg Length : 159018
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_anoush.jpg');/g" >> t130_extract_command;
>>
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200010559696826186440101919559696826248930896218212351958013356713020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
+>>extract lobtofile(LOB 'LOBH0000000200010219168903258881727719219168903363726830218212356997406948130020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
Success. Targetfile :tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
@@ -631,7 +728,7 @@ And the dish ran away with the fork !
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/lobs\/tlob130_txt2.txt');/g" >> t130_extract_command;
>>
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200010559696826186441630019559696826257581553118212351958099882804020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_txt2.txt');
+>>extract lobtofile(LOB 'LOBH0000000200010219168903258883232319219168903372701511018212356997496619570020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_txt2.txt');
Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt Length : 19
--- SQL operation complete.
@@ -647,7 +744,7 @@ Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt Length : 19
>>sh rm t130_extract_command;
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/lobs\/tlob130_deep.jpg');/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200010559696826186441758719559696826264825758518212351958172401525020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_deep.jpg');
+>>extract lobtofile(LOB 'LOBH0000000200010219168903258883350719219168903379688308218212356997566552580020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_deep.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -663,7 +760,7 @@ Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg Length : 159018
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/lobs\/tlob130_anoush.jpg');/g" >> t130_extract_command;
>>
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200010559696826186440101919559696826248930896218212351958013356713020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush.jpg');
+>>extract lobtofile(LOB 'LOBH0000000200010219168903258881727719219168903363726830218212356997406948130020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
@@ -682,7 +779,7 @@ Column Name : c2
Input a filename to extract to :
Output File Name : lobc2out.jpg
Extracting lob handle for column c2...
-LOB handle for c2: LOBH0000000200010559696826186440101919559696826248930896218212351958013356713020"TRAFODION"."LOB130"
+LOB handle for c2: LOBH0000000200010219168903258881727719219168903363726830218212356997406948130020"TRAFODION"."LOB130"
Extracting LOB data length for the above handle...
LOB data length :230150
Extracting lob data into file in chunks of 1000 ...
@@ -963,7 +1060,7 @@ And the dish ran away with the spoon.
>>sh rm t130_extract_command;
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_deep2.jpg');/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200020559696826186444079619559696826279514148718212351958319078382020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
+>>extract lobtofile(LOB 'LOBH0000000200020219168903258885636519219168903393735875718212356997706941500020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
Success. Targetfile :tlob130_deep2.jpg Length : 159018
--- SQL operation complete.
@@ -972,7 +1069,7 @@ Success. Targetfile :tlob130_deep2.jpg Length : 159018
>>sh rm t130_extract_command;
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/lobs\/tlob130_anoush2.jpg');/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200030559696826186444079619559696826280142532318212351958325419986020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush2.jpg');
+>>extract lobtofile(LOB 'LOBH0000000200030219168903258885636519219168903394315005818212356997712891888020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush2.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_anoush2.jpg Length : 230150
--- SQL operation complete.
@@ -999,7 +1096,7 @@ Hey diddle diddle,
>>sh rm t130_extract_command;
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_anoush3.jpg',create,truncate);/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200030559696826186444611919559696826285313364218212351958377158869020"TRAFODION"."LOB130"
' , 'tlob130_anoush3.jpg',create,truncate);
+>>extract lobtofile(LOB 'LOBH0000000200030219168903258886158819219168903399547397218212356997765122427020"TRAFODION"."LOB130"
' , 'tlob130_anoush3.jpg',create,truncate);
Success. Targetfile :tlob130_anoush3.jpg Length : 230150
--- SQL operation complete.
@@ -1100,12 +1197,12 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT2
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864479209_0001
+ LOB Data File: LOBP_02191689032588893965_0001
LOB EOD : 0
LOB Used Len : 0
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864479209_0002
+ LOB Data File: LOBP_02191689032588893965_0002
LOB EOD : 0
LOB Used Len : 0
ColumnName : C4
@@ -1120,8 +1217,8 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT2
CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME
LOB_LOCATION LOB_DATA_FILE LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------- -----------------------
-TRAFODION LOB130 TLOB130GT2 C2
/lobs LOBP_05596968261864479209_0001 0 0
-TRAFODION LOB130 TLOB130GT2 C3
/lobs LOBP_05596968261864479209_0002 0 0
+TRAFODION LOB130 TLOB130GT2 C2
/lobs LOBP_02191689032588893965_0001 0 0
+TRAFODION LOB130 TLOB130GT2 C3
/lobs LOBP_02191689032588893965_0002 0 0
TRAFODION LOB130 TLOB130GT2 C4
External HDFS Location External HDFS File 0 0
--- 3 row(s) selected.
@@ -1142,17 +1239,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864476749_0001
+ LOB Data File: LOBP_02191689032588891420_0001
LOB EOD : 15
LOB Used Len : 15
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864476749_0002
+ LOB Data File: LOBP_02191689032588891420_0002
LOB EOD : 15
LOB Used Len : 15
ColumnName : C4
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864476749_0003
+ LOB Data File: LOBP_02191689032588891420_0003
LOB EOD : 45
LOB Used Len : 45
@@ -1162,9 +1259,9 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME
LOB_LOCATION LOB_DATA_FILE LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------- -----------------------
-TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_05596968261864476749_0001 15 15
-TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_05596968261864476749_0002 15 15
-TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_05596968261864476749_0003 45 45
+TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_02191689032588891420_0001 15 15
+TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_02191689032588891420_0002 15 15
+TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_02191689032588891420_0003 45 45
--- 3 row(s) selected.
>>delete from tlob130gt where c1=2;
@@ -1181,17 +1278,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864476749_0001
+ LOB Data File: LOBP_02191689032588891420_0001
LOB EOD : 30
LOB Used Len : 25
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864476749_0002
+ LOB Data File: LOBP_02191689032588891420_0002
LOB EOD : 31
LOB Used Len : 26
ColumnName : C4
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864476749_0003
+ LOB Data File: LOBP_02191689032588891420_0003
LOB EOD : 71
LOB Used Len : 56
@@ -1201,9 +1298,9 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME
LOB_LOCATION LOB_DATA_FILE LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------- -----------------------
-TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_05596968261864476749_0001 30 25
-TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_05596968261864476749_0002 31 26
-TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_05596968261864476749_0003 71 56
+TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_02191689032588891420_0001 30 25
+TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_02191689032588891420_0002 31 26
+TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_02191689032588891420_0003 71 56
--- 3 row(s) selected.
>>
@@ -1365,12 +1462,12 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130EXT
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864491728_0001
+ LOB Data File: LOBP_02191689032588906132_0001
LOB EOD : 70
LOB Used Len : 42
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864491728_0002
+ LOB Data File: LOBP_02191689032588906132_0002
LOB EOD : 125
LOB Used Len : 68
ColumnName : C4
@@ -1385,8 +1482,8 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130EXT
CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME
LOB_LOCATION LOB_DATA_FILE LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------- -----------------------
-TRAFODION LOB130 TLOB130EXT C2
/lobs LOBP_05596968261864491728_0001 70 42
-TRAFODION LOB130 TLOB130EXT C3
/lobs LOBP_05596968261864491728_0002 125 68
+TRAFODION LOB130 TLOB130EXT C2
/lobs LOBP_02191689032588906132_0001 70 42
+TRAFODION LOB130 TLOB130EXT C3
/lobs LOBP_02191689032588906132_0002 125 68
TRAFODION LOB130 TLOB130EXT C4
External HDFS Location External HDFS File 0 0
--- 3 row(s) selected.
@@ -1403,7 +1500,7 @@ Column Name : c4
Input a filename to extract to :
Output File Name : lobc4ext.txt
Extracting lob handle for column c4...
-LOB handle for c4: LOBH0000000800030559696826186449172819559696826337745983818212351958901392808020"TRAFODION"."LOB130"
+LOB handle for c4: LOBH0000000800030219168903258890613219219168903450520326718212356998274785087020"TRAFODION"."LOB130"
Extracting LOB data length for the above handle...
LOB data length :19
Extracting lob data into file in chunks of 1000 ...
@@ -1428,7 +1525,7 @@ Table name : TRAFODION.LOB130.t130lob5
Input lob column name to get handle from :
Column Name : c2
Extracting lob handle for column c2...
-LOB handle for c2: LOBH0000000200010559696826186452001719559696826357840916318212351959102589093020"TRAFODION"."LOB130"
+LOB handle for c2: LOBH0000000200010219168903258893338319219168903470214248818212356998471792486020"TRAFODION"."LOB130"
>>select lobtostring(c2,20) from t130lob5;
(EXPR)
@@ -1445,7 +1542,7 @@ Table name : TRAFODION.LOB130.t130lob5
Input lob column name to get handle from :
Column Name : c2
Extracting lob handle for column c2...
-LOB handle for c2: LOBH0000000200010559696826186452001719559696826357840916318212351959102589093020"TRAFODION"."LOB130"
+LOB handle for c2: LOBH0000000200010219168903258893338319219168903470214248818212356998471792486020"TRAFODION"."LOB130"
>>select lobtostring(c2,40) from t130lob5;
(EXPR)
@@ -1462,7 +1559,7 @@ Table name : TRAFODION.LOB130.t130lob5
Input lob column name to get handle from :
Column Name : c2
Extracting lob handle for column c2...
-LOB handle for c2: LOBH0000000200010559696826186452001719559696826357840916318212351959102589093020"TRAFODION"."LOB130"
+LOB handle for c2: LOBH0000000200010219168903258893338319219168903470214248818212356998471792486020"TRAFODION"."LOB130"
>>select lobtostring(c2,20) from t130lob5;
(EXPR)
@@ -1479,7 +1576,7 @@ Table name : TRAFODION.LOB130.t130lob5
Input lob column name to get handle from :
Column Name : c2
Extracting lob handle for column c2...
-LOB handle for c2: LOBH0000000200010559696826186452001719559696826357840916318212351959102589093020"TRAFODION"."LOB130"
+LOB handle for c2: LOBH0000000200010219168903258893338319219168903470214248818212356998471792486020"TRAFODION"."LOB130"
>>select lobtostring(c2,40) from t130lob5;
(EXPR)
@@ -1506,7 +1603,7 @@ zzzzzzzzzzzzzzzzzzzz
C2
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------
-LOBH0000000200010559696826186449172819559696826371325150818212351959237435210020"TRAFODION"."LOB130"
<TRUNCATED>