by: Nile |
last post by:
I am having a problem with my application that uses ODBC. I am doing
the following:
* prepare a statement
* Bind
* execute
The problem is that my application needs to accept only insert...
|
by: Mike |
last post by:
Envirnoment is UDB 7.2 fp9 on AIX.
I'm familiar with using "dynexpln" for quickly comparing
access plans for directly executable queries.
dynexpln docs suggest it cannot work with sql that...
|
by: Marc DVer |
last post by:
I am trying to create a query that can be loaded as a querydef object
but not having to assign values to the parameters if I don't want to.
Normally when using a parameter query in VBA my code...
|
by: Vaelek |
last post by:
Hello,
I'm somewhat new to DB programming and have a question. I am now taking
over an application that a previous programmer had written and he had
made use of the Parameter.Add function for DB2...
|
by: Martin Evans |
last post by:
Hi,
I'm getting:
DBD::DB2::db do failed: SQL0440N No
authorized routine named "CONCAT" of type "FUNCTION" having compatible
arguments was found. SQLSTATE=42884
for some SQL like this:
|
by: =?ISO-8859-2?Q?Gregor_Kova=E8?= |
last post by:
Hi!
Is it possible to use parameter markers like this:
1.) SELECT * FROM TABLE1 WHERE FIELD1 LIKE '%?%'
If I now set parameter 1 to '' (empty string) I don't get any rows back,
but if I run:...
|
by: TrevRex |
last post by:
Hello,
I work for a non-profit in San Diego as a GIS Specialist. I have had to teach myself about some scripting to create some dynamic maps, but I am still very limited in my skills, so I have...
|
by: PaulR |
last post by:
Hi,
(DB2 LUW v8.2)
When using parameter markers how does the optimizer evaluate filter
factors?
- and is it able to make use of distribution stats. for parm.
markers?
The reason I ask, is...
|
by: uwcssa |
last post by:
I am runnig v95.
I have a query "select * from A, B where B.b<2000"
I create a MQT as "select * from A,B where B.b<2000" (identitcal to
the query), and the optimizer will use this MQT to...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
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...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
|
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...
|