| Author |
Message |
 Topic: UTF-8 to ISO-8859-8 EBCDIC Conversion |
18tillidie
Replies: 2
Views: 3979
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Sep 03, 2020 2:12 pm Subject: UTF-8 to ISO-8859-8 EBCDIC Conversion |
Hi,
I need to convert a file on Unix UTF-8 to ebcdic ISO-8859-8 format. Need help to identify the exact ccsid and encoding for conversion.
I am using SFTP mechanism of the file input( pull utf-8 ... |
| Topic: Compute node Transaction. |
18tillidie
Replies: 1
Views: 1985
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 27, 2020 11:02 am Subject: Compute node Transaction. |
Hi I am new to IIB and I need help to know the reason why the transaction is not being rolled back for a DB insert inside a while loop.
The compute node transaction property is set to 'Automatic'
... |
| Topic: DFDL Double Quotes for NULL or any value for CSV |
18tillidie
Replies: 6
Views: 10887
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 21, 2020 9:51 am Subject: DFDL Double Quotes for NULL or any value for CSV |
Issue Resolved, Thank you @timber owe you 
Went to the DFDL - http://www.ibm.com/dfdl/CommaSeparatedFormat >> Schema location in the Library project >> opened with DFDL editor ... |
| Topic: DFDL Double Quotes for NULL or any value for CSV |
18tillidie
Replies: 6
Views: 10887
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 21, 2020 7:15 am Subject: DFDL Double Quotes for NULL or any value for CSV |
'TRY' comes out as only TRY I need it in double quotes.
Forgot to mention I am opening the csv file in notepad ++ |
| Topic: DFDL Double Quotes for NULL or any value for CSV |
18tillidie
Replies: 6
Views: 10887
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 21, 2020 7:12 am Subject: DFDL Double Quotes for NULL or any value for CSV |
| 'TRY' comes out as only TRY I need it in double quotes. |
| Topic: DFDL Double Quotes for NULL or any value for CSV |
18tillidie
Replies: 6
Views: 10887
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 21, 2020 6:57 am Subject: DFDL Double Quotes for NULL or any value for CSV |
Hi I am new to IIB,
Need help in sending "" (double quotes in case the value is NULL, or any value with double quotes.)
I have 2 DFDLs created Input and Output I am using the below cod ... |
| Topic: Cast for Decimal Amount |
18tillidie
Replies: 3
Views: 2459
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 16, 2020 10:34 am Subject: Cast for Decimal Amount |
Thanks Vitor, issue resolved, changed the data type to Decimal all through, in the code and in the procedure and it worked. Oracle datatype NUMBER takes both integer and decimal values.
SET inAmoun ... |
| Topic: Cast for Decimal Amount |
18tillidie
Replies: 3
Views: 2459
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 16, 2020 7:01 am Subject: Cast for Decimal Amount |
Hello Folks,
I am new to esql and I request help with the below line of code -
SET inAmount = ROUND((CAST(SUBSTRING(ref.body1 FROM 31 FOR 10) AS DECIMAL)/100), 2);
The SUBSTRING is coming as ... |
| Topic: File Input Node FTP Transfer |
18tillidie
Replies: 1
Views: 2751
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 19, 2020 7:13 am Subject: File Input Node FTP Transfer |
Hi I have a requirement to pull files from mainframe using fileInput Node.
I tried to configure the FTP Remote server properties giving the mainframe IP address and creating the configurable servic ... |
