Search results for query: *

Here's the structure of the ctl file. OPTIONS (SKIP=0) LOAD DATA INFILE "33.txt" BADFILE "33.bad" APPEND INTO TABLE upload FIELDS TERMINATED BY "|" TRAILING NULLCOLS ( JOB_NO CONSTANT '999 CUST_ID_OR_ORG_ID CHAR "ltrim(rtrim(:cust_id_or_org_id))", BATCH_NO CONSTANT '33'...

Hi there, Of late, we are experiencing a strange problem with sql*loader. It is populating some columns with values that are not in the raw file. For example., the raw file contains XXXXXXXX |99999999|436||||||||||||||| XXXXXXXX |44444444|311||||||||||||||| XXXXXXXX...

I have site server 3.0 as application server and sql server for database. I created a new screen to update a table and added to the manager. I am unable to update the table in the database. I can update the database connecting directly to sql server. I am unable figure out the reason for not...

I modified a table from 2 to 4 columns and insert statement accordingly. When I make a transaction I am getting following error [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or number of supplied values does not match table definition. How do I fix this?

Hi, I am working for a small company which sell travel accessories. I am currently maintaining their website. The current website was developed in 2000. The platform they used is SQL Server 7.0, Site Server 3.0 and Imail. I am new to this environment and I want to create a dev environment for...

Thanks for your responses and input. The PC microphone is working now. Roger, I tried what you have written and still had no response. I returned the mic to the store and picked another one and it worked like a charm. Thanks again, VDS

The microphone I have attached to the PC does not show any signs of picking up sound. I have tried all the tricks mentioned in the troubleshooting guides and various sites in the internet. Still, no response. Any ideas ? Vds

We have a compaq proliant (don't remember the model #) with Raid 5. It has NT4 sp 5. Can we run defragmenter on it ?