Within a function, a query is built which can be quite complex. The query is a varchar which is manipulated by the function.
What is the syntax to execute the query? The result set is functions return (returns a table).
Thanks,
JB
I have a function that has a varchar about 300 characters. When I run the insert command from a function I receive the error SQL0433N - Value .... is too long SQLSTATE=22001.
If I run the query outside of the function it seems to work fine. I read about char limitations of 255 characters...
With a batch file, the first command executes and finishes prior to the second command starting.
Is there a way to run all the statements at once like & in a shell script?
On a closed thread Ken suggested escaping the " (ie \)"
What does this mean - are there any good references to escape keys?
==== Highlights from closed message =============
KenCunningham
Have you tried escaping the " (ie \")?
Perhaps a simple one, but I could do with a pointer here.
I...
How would you get the process id for a roll forward command?
Only looking for the PID.
ps -r | grep -i ?rollforward?
If I use ps -r pid, it only returns the number but I have no way to know that i came from a roll forward command.
Is there a way to look to see if a process is running for more than 3 hours. If it is running more than 3 hours, it should echo a simple failure message.
#identify process to kill
STARTDATE=`date -d +%s`
# Timelimit in seconds
TIMELIMIT = 10800
CDATE=`date -d +%s`
DIFF = CDATE - STARTDATE...
When using a base underlining table to query data that is already calculated in the MQT table, I assume the system would pull from the MQT table.
What conditions "encourage" the system to pull from the MQT table rather than the underlining base tables.
trying to create a MQT and it fails with error:
During SQL processing it returned:
SQL0206N "f" is not valid in the context where it is used.
SQLSTATE=42703
create table user.ytable as (select PERIOD, a, b, c, D, e sum(f) as sum_f, min (f) as min_f, g
from USER.yraw
group by grouping...
I am exporting a table from db1 to db2 and the dialog titled: "Export table to..." is extremely slow. I am running only on my local drive which is relatively quick.
-JB
In the current schema, there is one master table with a colors sub-table and location sub table. Master has a 1 to many relationship with both colors and location.
There may be merit in creating two separate sql statements in what may be a subreport.
The goal is to display the master item...
I am supporting an old ASP app that uses the MS Listview control (mscomctl.ocx). In the asp code, I notice there are param name such as multiselect, labelwrap, etc. that set the properties for the control. Is there any reference or support for unicode? Specifically the display of Japanese or...
Installing our software - caused several temp files to be dumped into the root of the hard drive. This then causes an NTLDR error as there are too many files.
What is the best way to be able to access the local drive to delete the files. I have used bootdisk which does not give me access.
Received error in the log: Data source name not found and no default driver specified
This occurred when installing the developer edition of SQL Server. The machine is setup with Japanese regional settings and previously had an instance of MSDE before. MSDE has been removed and nothing...
I am very new to linux. I am able to mount a hard drive with the GUI. But, it is read-only. How can I mount the drive for read write...
mount /mnt/hda2 -rw
??
Thanks,
JB
We have a goofy implementation of a multiple join.
Table Customers has a bits field that contains a relationship to associations. A customer can have 0, 1 or many associates.
The poor implementation has a customer.associationid = 16 which represents the record with id = 5.
16 (dec) = 10000...
We have identified an issue when uninstalling MSDE and an active process to the db exists, it creates an awkward state of the db.
We would like to kill all processes, stop the sql services and uninstall.
Are there cmd line commands to get this done?
Thanks,
JB
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.