Skip to content

Instantly share code, notes, and snippets.

@GiuseppeChillemi

GiuseppeChillemi/gist:884b519f8367fe9096b198c548605685

Created April 9, 2022 17:54
Show Gist options
  • Save GiuseppeChillemi/884b519f8367fe9096b198c548605685 to your computer and use it in GitHub Desktop.
Save GiuseppeChillemi/884b519f8367fe9096b198c548605685 to your computer and use it in GitHub Desktop.
Download ZIP
Next Next
Raw
gistfile1.txt
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
--------------------------------------------------------------------------------
---------------------------------------------------
03A9C428: 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
--------------------------------------------------------------------------------
---------------------------------------------------
03A9C428: 5900
Y.
--------------------------------------------------------------------------------
---------------------------------------------------
]
info: 10003 catalog-name
PICK-METADATA [
SQLGetInfo(10003) 0
--------------------------------------------------------------------------------
---------------------------------------------------
03A9C428: 5900
Y.
--------------------------------------------------------------------------------
---------------------------------------------------
]
info: 10004 collation-seq
PICK-METADATA [
SQLGetInfo(10004) 0
--------------------------------------------------------------------------------
---------------------------------------------------
03A9C428: 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 @ 002A0598
]
[block]
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 @ 03A9A0E8
SET-STATEMENT [
SQLSetStmtAttr 0
]
SET-STATEMENT [
SQLSetStmtAttr 0
]
SET-STATEMENT [
SQLSetStmtAttr 0
]
allocate name, 256 bytes @ 03A9A118
SQLDescribeCol 0
sql-type = 1, col-size = 6
allocate buffer, 140 bytes @ 03A9A220...03A9A2AB
allocate strlen, 40 bytes @ 03A9A2B8
SQLBindCol 0
c-type = 65528
SQLDescribeCol 0
sql-type = 65526, col-size = 1073741823
allocate buffer, 0 bytes @ 03A9A2E8...03A9A2E7
allocate strlen, 40 bytes @ 03A9A2F8
free name @ 03A9A118
]
FETCH-COLUMNS [
window: 10
status: 03A9A0E8
SQLFetchScroll 0
fetched: 002A0598 (10 rows)
--------------------------------------------------------------------------------
---------------------------------------------------
03A9A220: 28c4 a903 c000 2a00 2000 6400 6900 2000 7300 7400 7200 6900 6e00 6
700 6100 2000 (Ä©.À.*. .d.i. .s.t.r.i.n.g.a. .
03A9A240: 6400 6900 2000 6300 6f00 6e00 6e00 6500 7300 7300 6900 6f00 6e00 6
500 2000 6e00 d.i. .c.o.n.n.e.s.s.i.o.n.e. .n.
03A9A260: 6f00 6e00 2000 7600 6100 6c00 6900 6400 6f00 2e00 0000 0000 0800 0
008 5ae2 0600 o.n. .v.a.l.i.d.o...........Zâ..
03A9A280: 789d a903 9805 2a00 6f00 6e00 6e00 3a00 2000 3000 3400 3400 3000 3
900 3500 4200 x.©...*.o.n.n.:. .0.4.4.0.9.5.B.
03A9A2A0: 3800 0000 0000 0000 0200 0103
8...........
--------------------------------------------------------------------------------
---------------------------------------------------
--------------------------------------------------------------------------------
---------------------------------------------------
03A9A2E8:
--------------------------------------------------------------------------------
---------------------------------------------------
]
return-columns
[
[none deferred]
[none deferred]
[none deferred]
[none deferred]
[none deferred]
[none deferred]
[none deferred]
[none deferred]
[none deferred]
[none deferred]
]
FETCH-COLUMNS [
window: 10
status: 03A9A0E8
SQLFetchScroll 100
]
return-columns
[]
actor/pick
FETCH-VALUE [
allocate buffer, 4096 bytes @ 03A9C428 for column 2
SQLGetData 65535
DIAGNOSE-ERROR [
allocate state, 12 bytes @ 03A9A328
allocate message, 4096 bytes @ 03A9E440
SQLGetDiagRec 0
--------------------------------------------------------------------------------
---------------------------------------------------
03A9E440: 5b00 4d00 6900 6300 7200 6f00 7300 6f00 6600 7400 5d00 5b00 4400 7
200 6900 7600 [.M.i.c.r.o.s.o.f.t.].[.D.r.i.v.
03A9E460: 6500 7200 2000 4d00 6100 6e00 6100 6700 6500 7200 2000 4f00 4400 4
200 4300 5d00 e.r. .M.a.n.a.g.e.r. .O.D.B.C.].
03A9E480: 2000 5300 7400 6100 7400 6f00 2000 6400 6500 6c00 2000 6300 7500 7
200 7300 6f00 .S.t.a.t.o. .d.e.l. .c.u.r.s.o.
03A9E4A0: 7200 6500 2000 6e00 6f00 6e00 2000 7600 6100 6c00 6900 6400 6f00 2
e00 r.e. .n.o.n. .v.a.l.i.d.o...
--------------------------------------------------------------------------------
---------------------------------------------------
24000 0 [Microsoft][Driver Manager ODBC] Stato del cursore non valido.
SQLGetDiagRec 100
free state @ 03A9A328
free message @ 03A9E440
]
*** Script Error: ODBC error: ["24000" 0 {[Microsoft][Driver Manager ODBC] Stato
del cursore non valido.}]
*** Where: ctx||440~fetch-value
*** Near : pick st 2 close cn If
*** Stack: do-file
>>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment