26 | April | 2018 | Michael Ellerbeck

twitter
- My latest #scribit fun! https://t.co/lyUMs1y1IZ 1 month ago
- My newest #scribit friend R2D2 credit to Sam Hallows https://t.co/fhF0lQ0RbL 2 months ago
- Welcoming R2D2 to my #scibit family. Credit Sam Hallows https://t.co/yIBLJpOgkl 2 months ago
- @Scribit_Design :) twitter.com/mellerbeck/sta… 2 months ago
- @ccostan ow 2 months ago
- teaching my kids to write on walls.... #scribit https://t.co/DRgdfXYZi0 2 months ago
- using the 'illustrated artistic portrait' feature #scribit https://t.co/Kg9wxuhuQE 2 months ago
- #scribit more scribit shots https://t.co/UlX2qYoU0N 2 months ago
- #scribit After the learning curve, got my #scribit up and running! https://t.co/arGPxzStSt 2 months ago
- Good smells for software packages #inductiveautomation #ignition michaelellerbeck.com/2019/09/20/goo… https://t.co/N67Pbx8iw1 2 months ago
- wahoo my #scribit is on its way! 2 months ago
- failed to initialize container mounts: failed to create overlay fs for container: mounting overlay solution GreenGr… twitter.com/i/web/status/1… 3 months ago
- Oracle Query Hint michaelellerbeck.com/2019/08/02/ora… 4 months ago
- NtCreateFile(\Device\VBoxDrvStub) failed: 0xc000000034 fix michaelellerbeck.com/2019/07/09/ntc… 5 months ago
- Balluff + PRTG +IoT michaelellerbeck.com/2019/06/25/bal… https://t.co/HQPQonQhgg 5 months ago

Call stored procedure Oracle ODBC

Posted on April 26, 2018 by mellerbeck

Use

SQL CALL

https://community.qlikview.com/thread/12849

Filed under: Uncategorized | Leave a comment »

Oracle in OraClient 12Home2, #Qlikview, and case of field names capitalization

Posted on April 26, 2018 by mellerbeck

This was an annoying one for a bit.

Say you have this Qlikview script

LOAD

Sales_Order

;

Select ORDER_NUMBER as Sales_Order from…. ;

Well, it won’t work because the Oracle ODBC driver uppers all the returned field names, or Oracle does? Who knows?

Anyways, to make it work

LOAD

SALES_ORDER

Filed under: Uncategorized | Leave a comment »