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 Index » Search

 Search found 3 matches
Author Message
  Topic: How to select NULL value from SELECT?
et381

Replies: 6
Views: 2176
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Jul 15, 2009 12:02 am   Subject: How to select NULL value from SELECT?
Thanks, ended up doing some post processing after the select to set NULL.
  Topic: How to select NULL value from SELECT?
et381

Replies: 6
Views: 2176
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon Jul 13, 2009 3:16 pm   Subject: How to select NULL value from SELECT?
Any pointers to what the syntax might be to achieve this?

The scnerio is for SELECT to fetch data from a database and the database column field is nullable, hence wants to SELECT the NULL value int ...
  Topic: How to select NULL value from SELECT?
et381

Replies: 6
Views: 2176
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Thu Jul 09, 2009 6:04 pm   Subject: How to select NULL value from SELECT?
Hi All,

Got a quick question regarding ESQL

If I want to set a node value to NULL, I could do something like this.

SET OutputRoot.MRM.SomeNode VALUE = NULL;

Can I achieve something similar ...
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.