473,662 Members | 2,724 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Embedded SQL Select Statement using CICS

1 New Member
Hi
I am trying to select multiple rows from my table based on the search criteria.
in cics cobol.
with a host variable.
i am using a SELECT statement with LIKE :ws-custid.
here the like is pointing to a host variable.
The ws-custid has value 'C%%%' . the custid field length is 4 .
When i use this with cobol db2 it works with display statement. But this same thing doesn't work with CICS cobol DB2.
Sep 27 '07 #1
0 1690

Sign in to post your reply or Sign up for a free account.

Similar topics

4
4785
by: jrefactors | last post by:
I want to distinguish between static SQL, dynamic SQL, and embedded SQL, but couldn't find too much useful resources in the web. For example, if we put SQL statements (SELECT, INSERT, UPDATE, etc...) inside an application (e.g. Java application, VB application, etc...), do we consider those SQL statements as static SQL? or embedded SQL? How about dynamic SQL? any practical examples? Please advise. thanks!!
11
4253
by: Mark Yudkin | last post by:
The documentation is unclear (at least to me) on the permissibility of accessing DB2 (8.1.5) concurrently on and from Windows 2000 / XP / 2003, with separate transactions scope, from separate threads of a multithreaded program using embedded SQL. Since the threads do not need to share transaction scopes, the sqleAttachToCtx family of APIs do not seem to be necessary. <quote> In the default implementation of threaded applications against...
3
5946
by: Dad | last post by:
Is it possible to invoke JCL or CICS from a stored procedure? I am working on a integration project in which I need one system to invoke another. The plan is to write data into tables in DB2 and then call existing programs to process the data. We don't have CICS TS or similar, so I need a way to trigger backend processing.
1
1848
by: bporter | last post by:
Has anyone used the new C support option for XPEDITER/CICS (mainframe debugging)? I believe it is in beta now - would be interested in any feedback. I have used their C support for their batch debugger and am pretty excited they are going to have it in CICS too. Any insight would be helpful. Thanks, Brian
25
11123
by: VictorReinhart | last post by:
Hi, I am intersted in trying to reduce the cost of C# development, by reducing the number of lines of code. In my opinion, as a business developer, the biggest opportunity to reduce the number of lines of code is in database access. My reality is that I use relational databases a lot. Other constructs, such as flat files, Web Services, arrays, etc I don't use very much. My data is stored on relational databases. I think that's...
9
2935
by: Dranai | last post by:
I'm looking into a problem a friend is having, and I'll say right off the bat that I work with with php and MySQL, and not MS SQL. What he is attempting to do (in MS SQL) is take two database fields from a table (string fields), multiply them together, and put them into a third field. This third column in the table has not yet been created the time of running the query. If it needs to be multiple queries, that is fine. My first...
0
1102
by: Stephanie | last post by:
Hi all, I need to call RPCs that are on a OS/390 CICS environement. It seems like there is a socket server running on CICS called CICS Socket Listner. I want to write a Socket client in C# to connect to the listner and call the RPCs... I don't know what to send to this listner. Does someone have some experience with the subject? Thanks Stephanie
4
4240
by: osmarjunior | last post by:
Hi. I made a method to execute queries in my database (Firebird embedded v.1.5.3). The Database class contains methods to create the database specific objects. public static DbDataReader ExecuteReader(String query) { // Creates the DbCommand DbCommand command = Database.GetCommand();
1
2321
by: sushanta123 | last post by:
Hi every1, Actually i have doubt in CICS apart from DB2.. Through my application screen in CICS i want to send a help screen more likely a pop-up box with a different background color. This help screen will a small screen probably with SIZE=(08,80) and it should contain the boundary just like a pop-up box and it should be displayed in that previous screen itself without erasing that one. But i am not sure whether this is possible in...
0
8435
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8345
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8768
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8547
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8633
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6186
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5655
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4181
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
1754
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.