| Author |
Message |
 Topic: Problem with csv file with JText adapter |
pradha
Replies: 5
Views: 2800
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Mon May 26, 2008 10:39 pm Subject: Ignoring first message in a csv file |
| FYI I have a flow, source and target message set. My source is tds and target is xml. I pass csv file as input. I have configured EndBODelimiter as EOL and Data Processingmode as Text which helps me t ... |
| Topic: Problem with csv file with JText adapter |
pradha
Replies: 5
Views: 2800
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon May 26, 2008 10:11 pm Subject: Ignore first message in a csv file |
| Thanks for your kind reply. And I'm using JTEXT adapter. I think I'm clear in my subject. |
| Topic: Problem with csv file with JText adapter |
pradha
Replies: 5
Views: 2800
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon May 26, 2008 9:34 pm Subject: Problem with csv file with JText adapter |
| I have an issue regarding passing csv file as input to an adapter. While giving a csv file as input I have found solution to convert it to BO's but in csv file first message will be the field names. I ... |
| Topic: Timestamp issue |
pradha
Replies: 7
Views: 5832
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 11, 2008 2:49 am Subject: Timestamp issue |
I found that extract function is used as following,
---------------------
EXTRACT(YEAR FROM CURRENT_DATE)
and
EXTRACT(HOUR FROM LOCAL_TIMEZONE)
both work without error, but
EXTRACT(DAY FROM CUR ... |
| Topic: Timestamp issue |
pradha
Replies: 7
Views: 5832
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 11, 2008 2:03 am Subject: Timestamp issue |
| It is the mapping field and also I have found that we can extract Time zone only from Local_Timezone. Do u have any solution for that. |
| Topic: Timestamp issue |
pradha
Replies: 7
Views: 5832
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 11, 2008 1:34 am Subject: Timestamp issue |
Thank u for having replied me.
Broker version 6
Code : SET messagedate = SUBSTRING(CAST(InputHdrRef.nsNGSubRed:Timestamp AS CHARACTER) FROM 12 FOR 10);
SET OutputHdrRef.MsgDate = CAST(messag ... |
| Topic: Timestamp issue |
pradha
Replies: 7
Views: 5832
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Feb 10, 2008 10:03 pm Subject: Timestamp issue |
| How to get '12:00:00.000+05:30' in the output message when timestamp '2001-01-01'T'12:00:00+05:30' being input message. I get only 12:00:00 in the output message as MB fails to retrieve time zone alon ... |
