About kbachl

kbachl · 05-09-2024

Hi,following code: sql = <<-END_SQL select count("ItemCode") from "TEST2024"."OITM" where "ItemCode" = ? END_SQL p item_code # this won't work, allways returns [0,0]! stmt = @@api.hanaclient_prepare @@co...

kbachl · 08-29-2015

Hello,I've created a XSJob and it really was really easy to setup. However, my job has a quite short call frequency, its set to* * * * * */3 meaning each 3 seconds its triggered. It all works perfect, but I noticed that the browser view of its job-ad...

kbachl · 07-21-2015

Hello,is there any way to directly write to a file based on the hana server from inside HANA using some kind of trigger? (or maybe using XSJS?)I know that there is a file-api in SPS 09, but sadly I'm stuck with SPS 08 currently and I'm not sure if th...

kbachl · 04-21-2015

Hello,we do some kind of data transfomation and import/export via XSJS and somehow need to log this. Since the scripts take some time and do a bit of a work, the idea of putting it all into a HANA table looks not so promising to me (talking about 200...

kbachl · 03-17-2015

Hello,I've got some problems regarding the consuming of Batch-Responses of OData. I've successful send out an OData Batch request via POST to $Batch;The returned request however seems to be inaccessible to me in XSJS (this is just a shortened example...

kbachl

@jeff_albionThanks for the update!I hardly can go on to ruby 2.7 as I'm doing a current new rails project and ruby 3.1.0 is the new baseline for upcoming rails 7.2, me using ruby 3.3.1.Beside ruby 2.7 is EOL since 2023-03-31. Since I only need this o...

kbachl

I made an "Answer" below - seems I cant directly reply to you

kbachl

@jeff_albionThanks for trying to help.I tried your example and it worked as long as the type was integer. As soon as I changed the SQL to use would use String it broke, see:... sql = <<-END_SQL select 42 from "SYS"."DUMMY" where 'Test...

kbachl · 11-01-2016

Why are I'm unable to post any comment and it instead tells me "We're sorry, but you do not have enough permissions to post a comment.If you believe this to be in error, contact your system administrator."And even MORE IMPORTANT: WHO THE HECK IS THE ...

kbachl · 09-13-2016

Since you talk about "we" I suppose you are from the SAP team.B1 HANA only supports SLES as of now.SuSe however changed their licensing drastically this year, cancelling the self-service-support-subscription options and this leading to a dramatically...

User Statistics

User Activity

Ruby API returns different result based on same SQL but prepared vs execute_direct

XSJOB and its log

write to file

XSJS and need for logging

XSJS and OData-Batch result consuming

Re: Ruby API returns different result based on same SQL b...

Re: Ruby API returns different result based on same SQL but prepared vs execute_direct

Re: Ruby API returns different result based on same SQL b...

Re: What do you think about our new Q&A platform?

Re: The mist of SUSE, SAP Business One and HANA versions made clear