| Author |
Message |
 Topic: How to SET NULL as String when calling a Update Query |
apmohan
Replies: 4
Views: 4511
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri Mar 12, 2021 3:46 pm Subject: Re: How to SET NULL as String when calling a Update Query |
... when i do COLEASE(name,NULL) doesnt work.
What do you mean by doesn't work? Does it throw an error? Something else?
Sorry Bruce for not clarifying.. I getting an error that the Variable quer ... |
| Topic: How to SET NULL as String when calling a Update Query |
apmohan
Replies: 4
Views: 4511
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Mar 12, 2021 7:01 am Subject: How to SET NULL as String when calling a Update Query |
Do you mean null or ‘null’ ?
I mean NULL only I don't want as String'NULL' |
| Topic: How to SET NULL as String when calling a Update Query |
apmohan
Replies: 4
Views: 4511
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Mar 12, 2021 4:55 am Subject: How to SET NULL as String when calling a Update Query |
Hello All,
I am writing an ESQL Code to update the Database Table with the provided values,
Request (JSON)
{
"updateEntries":
SET query = 'UPDATE Employee SET NAME = ISNULL(' ... |
| Topic: Passing Username/Password as application/x-www-form-urlencod |
apmohan
Replies: 11
Views: 41138
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Feb 10, 2021 9:37 pm Subject: Re: Passing Username/Password as application/x-www-form-urle |
Thanks Vitor for the update, as advised I passed everything as Blob which resolved the issue 
SET OutputLocalEnvironment.Destination.HTTP.RequestLine.Method = 'POST';
DECLARE payload CHARA ... |
| Topic: Passing Username/Password as application/x-www-form-urlencod |
apmohan
Replies: 11
Views: 41138
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Feb 09, 2021 10:04 pm Subject: Re: Passing Username/Password as application/x-www-form-urle |
Also I asked the vendor but they aren't sure of it 
Well that's weird but not as unusual as it should be.
But in your first post you said:
I am passing the username/password as Key and Valu ... |
| Topic: Passing Username/Password as application/x-www-form-urlencod |
apmohan
Replies: 11
Views: 41138
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Feb 09, 2021 5:03 am Subject: Re: Passing Username/Password as application/x-www-form-urle |
Here if you see the Request Body just shows username and password, so I am not sure whether this is a JSON format or someother ?
Don't you think the best way is to query with the service provider ... |
| Topic: Passing Username/Password as application/x-www-form-urlencod |
apmohan
Replies: 11
Views: 41138
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 08, 2021 9:56 pm Subject: Re: Passing Username/Password as application/x-www-form-urle |
when i try to use postman, I am passing the username/password as Key and Value under Body with Content Type as "application/x-www-form-urlencoded".
hi...to add to Vitor's comment, lo ... |
| Topic: Passing Username/Password as application/x-www-form-urlencod |
apmohan
Replies: 11
Views: 41138
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 08, 2021 6:19 am Subject: Passing Username/Password as application/x-www-form-urlencod |
Neither of those methods add anything to the body of the call.
Your first example adds them to the parameters passed in the HTTP header, the second adds them as query items to the end of the URL. ... |
| Topic: Passing Username/Password as application/x-www-form-urlencod |
apmohan
Replies: 11
Views: 41138
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 08, 2021 4:29 am Subject: Re: Passing Username/Password as application/x-www-form-urle |
Hello All,
I am using IIB V10.0.0.18 and I want to do call a external rest to fetch a token, when i try to use postman, I am passing the username/password as Key and Value under Body with Content ... |
| Topic: Passing Username/Password as application/x-www-form-urlencod |
apmohan
Replies: 11
Views: 41138
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 08, 2021 4:17 am Subject: Passing Username/Password as application/x-www-form-urlencod |
Hello All,
I am using IIB V10.0.0.18 and I want to do call a external rest to fetch a token, when i try to use postman, I am passing the username/password as Key and Value under Body with Content ... |
| Topic: Logging Data When Using FileInput Node |
apmohan
Replies: 7
Views: 6150
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 01, 2019 4:19 am Subject: Logging Data When Using FileInput Node |
We further assume the SHARED ROW OutFile is part of this process, another logging structure for an Output file,
You are right OutFile is to store the output file which is happening as expected.
... |
| Topic: Logging Data When Using FileInput Node |
apmohan
Replies: 7
Views: 6150
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 31, 2019 5:37 am Subject: Logging Data When Using FileInput Node |
Thanks Vitor for the reply
Well on the face of it I'd store the individual records in a Shared Row Variable (or the global cache - Shared Row is probably easier) and write them out on End Of Data. ... |
| Topic: Logging Data When Using FileInput Node |
apmohan
Replies: 7
Views: 6150
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 31, 2019 3:15 am Subject: Logging Data When Using FileInput Node |
Hello All,
I am using IIB V9.0 version where my requirement is to read a file line by line, where I need to cache the records line by line and when the End of Data is received those records should ... |
| Topic: Incorrect JSON Message Generating (\ Occuring in the JSON ) |
apmohan
Replies: 8
Views: 9163
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Feb 01, 2019 5:51 am Subject: Incorrect JSON Message Generating (\ Occuring in the JSON ) |
(1) Take a very simplistic solution and just produce a BLOB output message with the content set as a contraction of "
This has resolved the issue and I am able to hit the request as JSON and g ... |
| Topic: Incorrect JSON Message Generating (\ Occuring in the JSON ) |
apmohan
Replies: 8
Views: 9163
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Feb 01, 2019 12:54 am Subject: Incorrect JSON Message Generating (\ Occuring in the JSON ) |
| it is because escaped double quotes represent literal characters. Did you give try construct the JSON array as a CHARACTER string, CAST it as a BLOB, and then use the CREATE statement with PARSE claus ... |
