Search results for query: *

Hello all, The word document which was once in landscape view defaults as portrait view regardless of how the doc is saved any ideas on how to correct this? Also, the footers which used to display no longer displays. Thanks in advance.

What command can I use in Query Analyzer to view a stored procedure? I would like to read through a sp line by line but cannot remember the command. It is not sp_help procedure name nor is it execute procedure name. Thanks in advance.

Hello, Does anyone know where one can get trained in AIX in Southern Califoria? Thanks in advance.

How can one find out the Linux version and version numbers on an iSeries partition. The types would be SuSe. Thanks in advance.

Hi, How does one execute this SQL stored procedure in Sybase 12.5? declare @i integer set @i = 1 while @i <= 5000 begin insert into T00 (RECID) values (@i) insert into T50 (RECID) values (@i) set @i = @i + 1 end Thanks in advance.

Hi, For this stored procedure, I cannot make the counter work, any ideas? The table becomes populated with five 1's what I want is that the table is populated with 1,2,3,4,5. DECLARE i INTEGER := 1; BEGIN WHILE (i <= 5) LOOP insert into SLEONARD.T00 (RECID) values (1); COMMIT; insert into...

Hello, How can I run this SQL stored procedure in Oracle? declare @i integer set @i = 1 while @i <= 5000 begin insert into T00 values (@1) insert into T50 values (@1) set @i = @i + 1 end commit Thanks in advance!

When I use the Oracle Enterprise manager for 9i with the 92 DB and I attempt an insert to an NCHAR field I receive garbage data. Example Insert N'test' to a field which is NCHAR(10) nullable. the data when applied appears like so: T#E#S#T Any idea why this is happening? Thanks in advance.

I was wondering whether any of you have worked with creating an application which was converted to Unicode. If so what type of tests would you recommend prior to the translation\internationalization of the product. Thanks in advance.

Does anyone know where exactly one can find this. I am not looking for possible sites rather definite sites. Thanks in advance.

The rename command: rename table a to table b is incorrect if you are logged on as the administrator. I want to rename a table in the schema. That is: SL.table1 sl is the schema name.

I am using an emulator to access DB/2 files. I also use the SQL utility. I cannot use the standard SQL statement to return selected fields from a file. Example select fldchar1,fldchar2 from library/filename instead I have to use: select * from library/filename. How would one filter a select...

Does anyone know of any freeware for data generation. Basically a tool which could insert random data for SQL2K,Oracle,DB/2 databases? Thanks in advance. Shyamal

I am having problems inserting into a timestamp field Field: fldtimestamp (timestamp,null) insert into cnv_tmstmp (fldtimestamp) values ('10/01/01:15:10:111') or if i just put 10/01/01 I receive the following: Disallowed implicit conversion from data type varchar to data type timestamp...

I am attempting to insert into a destination table from two source tables in the same database with certain criteria. Table Names Table fields SRC: Table1 - (fldintkey,fldint1,fldchar) - all null SRC: Table2 - (fldintkey,fldint1,fldchar) - all null Dst: Table_Dst -(fldintkey,fldint1,fldchar)...

Anyone know what the maximum table joined can be in Oracle 8i\9i? Thanks in advance.

Anyone know what the maximum table joined can be on SQL2K? Thanks in advance.

A typical insert for an nchar field does not work: insert into DEV.SLEONTPS (FLDNCHAR) VALUES (&quot;test&quot;) I was told to use this: insert into DEV.SLEONTPS (FLDNCHAR) VALUES TRANSLATE(&quot;test&quot; USING NCHAR_CS); This still errors out with the following; ORA-00906: missing left...

As oracle 8i only has a date datatype for conversions such as SQL how does one input time and timestamp into oracle? Thanks in advance.

The following insert generates this error: INSERT INTO DEV.SLEONTPS (NVARCHAR,FLDDATE1) VALUES ('THIS','01/01/2001'); Error: INSERT INTO DEV.SLEONTPS (NVARCHAR,FLDDATE1) VALUES ('THIS','01-01-2001') * ERROR at line 1: ORA-01843: not a...