Skip to content

Instantly share code, notes, and snippets.

@GiuseppeChillemi

GiuseppeChillemi/gist:b945ca418dff41a77812a0c8c47d4461

Created April 7, 2022 22:20
Show Gist options
  • Save GiuseppeChillemi/b945ca418dff41a77812a0c8c47d4461 to your computer and use it in GitHub Desktop.
Save GiuseppeChillemi/b945ca418dff41a77812a0c8c47d4461 to your computer and use it in GitHub Desktop.
Download ZIP
Single column Attributi retrieve
Raw
gistfile1.txt
//////////////////// Without debug ///////////////////
>> do %odbc-test.red
[attributi]
--------------------------------------------------------------------------------
---------------------------------------------------
0375A1E8:
--------------------------------------------------------------------------------
---------------------------------------------------
[
[deferred]
]
*** Script Error: ODBC error: ["01004" 0 {[Microsoft][ODBC SQL Server Driver]Tro
ncamento a destra della string
*** Where: ctx||440~fetch-value
*** Near : pick st 'attributi close cn
*** Stack: do-file
>>
//////////// ON DEBUG CONSOLE ////////////////
SQLGetInfo(142) 0
]
info: 143 drop-view
PICK-METADATA [
SQLGetInfo(143) 0
]
info: 144 dynamic-cursor-attributes1
PICK-METADATA [
SQLGetInfo(144) 0
]
info: 145 dynamic-cursor-attributes2
PICK-METADATA [
SQLGetInfo(145) 0
]
info: 146 forward-only-cursor-attributes1
PICK-METADATA [
SQLGetInfo(146) 0
]
info: 147 forward-only-cursor-attributes2
PICK-METADATA [
SQLGetInfo(147) 0
]
info: 148 index-keywords
PICK-METADATA [
SQLGetInfo(148) 0
]
info: 149 info-schema-views
PICK-METADATA [
SQLGetInfo(149) 0
]
info: 150 keyset-cursor-attributes1
PICK-METADATA [
SQLGetInfo(150) 0
]
info: 151 keyset-cursor-attributes2
PICK-METADATA [
SQLGetInfo(151) 0
]
info: 152 odbc-interface-conformance
PICK-METADATA [
SQLGetInfo(152) 0
]
info: 153 param-array-row-counts
PICK-METADATA [
SQLGetInfo(153) 0
]
info: 154 param-array-selects
PICK-METADATA [
SQLGetInfo(154) 0
]
info: 155 sql92-datetime-functions
PICK-METADATA [
SQLGetInfo(155) 0
]
info: 156 sql92-foreign-key-delete-rule
PICK-METADATA [
SQLGetInfo(156) 0
]
info: 157 sql92-foreign-key-update-rule
PICK-METADATA [
SQLGetInfo(157) 0
]
info: 158 sql92-grant
PICK-METADATA [
SQLGetInfo(158) 0
]
info: 159 sql92-numeric-value-functions
PICK-METADATA [
SQLGetInfo(159) 0
]
info: 160 sql92-predicates
PICK-METADATA [
SQLGetInfo(160) 0
]
info: 161 sql92-relational-join-operators
PICK-METADATA [
SQLGetInfo(161) 0
]
info: 162 sql92-revoke
PICK-METADATA [
SQLGetInfo(162) 0
]
info: 163 sql92-row-value-constructor
PICK-METADATA [
SQLGetInfo(163) 0
]
info: 164 sql92-string-functions
PICK-METADATA [
SQLGetInfo(164) 0
]
info: 165 sql92-value-expressions
PICK-METADATA [
SQLGetInfo(165) 0
]
info: 167 static-cursor-attributes1
PICK-METADATA [
SQLGetInfo(167) 0
]
info: 168 static-cursor-attributes2
PICK-METADATA [
SQLGetInfo(168) 0
]
info: 169 aggregate-functions
PICK-METADATA [
SQLGetInfo(169) 0
]
info: 170 ddl-index
PICK-METADATA [
SQLGetInfo(170) 0
]
info: 171 dm-ver
PICK-METADATA [
SQLGetInfo(171) 0
--------------------------------------------------------------------------------
---------------------------------------------------
03AAC400: 3000 3300 2e00 3800 3100 2e00 3900 3600 3000 3000 2e00 3000 3000 3
000 3000 0.3...8.1...9.6.0.0...0.0.0.0.
--------------------------------------------------------------------------------
---------------------------------------------------
]
info: 172 insert-statement
PICK-METADATA [
SQLGetInfo(172) 0
]
info: 10002 describe-parameter
PICK-METADATA [
SQLGetInfo(10002) 0
--------------------------------------------------------------------------------
---------------------------------------------------
03AAC400: 5900
Y.
--------------------------------------------------------------------------------
---------------------------------------------------
]
info: 10003 catalog-name
PICK-METADATA [
SQLGetInfo(10003) 0
--------------------------------------------------------------------------------
---------------------------------------------------
03AAC400: 5900
Y.
--------------------------------------------------------------------------------
---------------------------------------------------
]
info: 10004 collation-seq
PICK-METADATA [
SQLGetInfo(10004) 0
--------------------------------------------------------------------------------
---------------------------------------------------
03AAC400: 4900 5300 4f00 2000 3800 3800 3500 3900 2d00 3100
I.S.O. .8.8.5.9.-.1.
--------------------------------------------------------------------------------
---------------------------------------------------
]
info: 10005 max-identifier-len
PICK-METADATA [
SQLGetInfo(10005) 0
]
info: 10021 async-mode
PICK-METADATA [
SQLGetInfo(10021) 0
]
info: 10024 driver-aware-pooling-supported
PICK-METADATA [
SQLGetInfo(10024) 0
]
info: 10025 async-notification
PICK-METADATA [
SQLGetInfo(10025) 0
]
actor/open: statement
OPEN-STATEMENT [
SQLAllocHandle 0
allocate fetched, 4 bytes @ 001DEFD8
]
SET-STATEMENT [
SQLSetStmtAttr 0
]
actor/insert
FREE-PARAMETERS [
]
FREE-COLUMNS [
]
FREE-STATEMENT [
SQLFreeStmt 0
SQLFreeStmt 0
SQLFreeStmt 0
]
PREPARE-STATEMENT [
SQLPrepare 0
]
EXECUTE-STATEMENT [
SQLExecute 0
]
describe-columns
COUNT-COLUMNS [
SQLNumResultCols 0
]
BIND-COLUMNS [
allocate status/value, 40 bytes @ 03AAA0E0
SET-STATEMENT [
SQLSetStmtAttr 0
]
SET-STATEMENT [
SQLSetStmtAttr 0
]
SET-STATEMENT [
SQLSetStmtAttr 0
]
allocate name, 256 bytes @ 03AAA110
SQLDescribeCol 0
sql-type = 65526, col-size = 1073741823
allocate buffer, 0 bytes @ 03AA6750...03AA674F
allocate strlen, 40 bytes @ 03AAA218
SQLBindCol 0
c-type = 65528
free name @ 03AAA110
]
[attributi]
FETCH-COLUMNS [
window: 10
status: 03AAA0E0
SQLFetchScroll 1
DIAGNOSE-ERROR [
allocate state, 12 bytes @ 03AAA110
allocate message, 4096 bytes @ 03AAC400
SQLGetDiagRec 0
--------------------------------------------------------------------------------
---------------------------------------------------
03AAC400: 5b00 4d00 6900 6300 7200 6f00 7300 6f00 6600 7400 5d00 5b00 4f00 4
400 4200 4300 [.M.i.c.r.o.s.o.f.t.].[.O.D.B.C.
03AAC420: 2000 5300 5100 4c00 2000 5300 6500 7200 7600 6500 7200 2000 4400 7
200 6900 7600 .S.Q.L. .S.e.r.v.e.r. .D.r.i.v.
03AAC440: 6500 7200 5d00 5400 7200 6f00 6e00 6300 6100 6d00 6500 6e00 7400 6
f00 2000 6100 e.r.].T.r.o.n.c.a.m.e.n.t.o. .a.
03AAC460: 2000 6400 6500 7300 7400 7200 6100 2000 6400 6500 6c00 6c00 6100 2
000 7300 7400 .d.e.s.t.r.a. .d.e.l.l.a. .s.t.
03AAC480: 7200 6900 6e00 6700 6100 2000 6400 6900 2000 6400 6100 7400 6900 2
e00 r.i.n.g.a. .d.i. .d.a.t.i...
--------------------------------------------------------------------------------
---------------------------------------------------
01004 0 [Microsoft][ODBC SQL Server Driver]Troncamento a destra della stringa di
dati.
SQLGetDiagRec 100
free state @ 03AAA110
free message @ 03AAC400
]
fetched: 001DEFD8 (1 rows)
--------------------------------------------------------------------------------
---------------------------------------------------
03AA6750:
--------------------------------------------------------------------------------
---------------------------------------------------
]
return-columns
[
[deferred]
]
actor/pick
FETCH-VALUE [
allocate buffer, 0 bytes @ 03AAC400
SQLGetData 65535
DIAGNOSE-ERROR [
allocate state, 12 bytes @ 03AAA110
allocate message, 4096 bytes @ 03AAD408
SQLGetDiagRec 0
--------------------------------------------------------------------------------
---------------------------------------------------
03AAD408: 5b00 4d00 6900 6300 7200 6f00 7300 6f00 6600 7400 5d00 5b00 4f00 4
400 4200 4300 [.M.i.c.r.o.s.o.f.t.].[.O.D.B.C.
03AAD428: 2000 5300 5100 4c00 2000 5300 6500 7200 7600 6500 7200 2000 4400 7
200 6900 7600 .S.Q.L. .S.e.r.v.e.r. .D.r.i.v.
03AAD448: 6500 7200 5d00 4900 6e00 6400 6900 6300 6500 2000 6400 6500 6c00 2
000 6400 6500 e.r.].I.n.d.i.c.e. .d.e.l. .d.e.
03AAD468: 7300 6300 7200 6900 7400 7400 6f00 7200 6500 2000 6e00 6f00 6e00 2
000 7600 6100 s.c.r.i.t.t.o.r.e. .n.o.n. .v.a.
03AAD488: 6c00 6900 6400 6f00 2e00
l.i.d.o...
--------------------------------------------------------------------------------
---------------------------------------------------
07009 0 [Microsoft][ODBC SQL Server Driver]Indice del descrittore non valido.
SQLGetDiagRec 100
free state @ 03AAA110
free message @ 03AAD408
]
*** Script Error: ODBC error: ["01004" 0 {[Microsoft][ODBC SQL Server Driver]Tro
ncamento a destra della string
*** Where: ctx||440~fetch-value
*** Near : pick st 'attributi close cn
*** Stack: do-file
>>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment