ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexSearch

Search found 9 matches
Author Message
Topic:UTF-8 to ISO-8859-8 EBCDIC Conversion
18tillidie

Replies: 2
Views: 1279

PostForum:WebSphere Message Broker 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: 865

PostForum:WebSphere Message Broker 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: 1354

PostForum:WebSphere Message Broker 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: 1354

PostForum:WebSphere Message Broker 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: 1354

PostForum:WebSphere Message Broker 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: 1354

PostForum:WebSphere Message Broker 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: 1042

PostForum:WebSphere Message Broker 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: 1042

PostForum:WebSphere Message Broker 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: 1275

PostForum:WebSphere Message Broker 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 ...
Page 1 of 1

Jump to:
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.