by: Andy |
last post by:
I have 2 databases, one that we use called MyShop and one that I develop on
called TestShop.
After I have a stored procedure working the way I want in TestShop , is
there a way to just copy the SP...
|
by: Robin Tucker |
last post by:
Hi,
I'm trying to determine with my program whether or not a given database
supports a given feature set. To do this I'm querying for certain stored
procedures in the sysobjects table and if...
|
by: jrefactors |
last post by:
I want to know the differences between SQL Server 2000 stored
procedures and oracle stored procedures? Do they have different
syntax? The concept should be the same that the stored procedures...
|
by: chettiar |
last post by:
I am trying to do the following from within a procedure.
set vcsql = 'Call SYSPROC.ADMIN_CMD(' || '''load from /dev/null of del
replace into bi.Provisioned_Spam''' || ')';
execute immediate...
|
by: Gregor KovaĨ |
last post by:
Hi!
I'm trying to use ADMIN_CMD procedure in my SQL procedure like this:
DROP PROCEDURE IMPORT_DATA#
CREATE PROCEDURE IMPORT_DATA()
SPECIFIC IMPORT_DATA
MODIFIES SQL DATA
NOT DETERMINISTIC...
|
by: jefftyzzer |
last post by:
Friends:
The (v9) documentation for invoking LOAD via the ADMIN_CMD SP has this
to say:
"Since all load processes (and all DB2 server processes, in general)
are owned by the instance owner,...
|
by: DR |
last post by:
what are the memory caps for threads running as a CLR stored procedure
executed by sql server 2005? is it limited by OS only or also by sql servers
memory limits? e.g. lets say my clr stored...
|
by: joachim.c.mueller |
last post by:
Hello,
is it not possible to load data with admin_cmd into a table?
This SP ended with SQL3304N The table does not exist.:
CREATE PROCEDURE ADM_LOAD ( )
DYNAMIC RESULT SETS 1
-- SQL...
|
by: David Beardsley |
last post by:
I'm trying to write a stored procedure that will terminate a load for
a given table using the SYSPROC.ADMIN_CMD procedure.
When I take the syntax that works using Quest:
LOAD
FROM '/dev/null'...
|
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: 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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
|
1
