cpyf and cpysplf: How to copy spool files and database files in AS/400?

Hi, Can you give me the what are the steps to copy the data from one pf to another pf using cpyf? and how to copy the data from spool file to database file using cpysplf?  

Girilabs130 pointsBadges:

Copy Table in SQLPLUS

How to copy a table from an access database using sqlplus

VB and Access5 pointsBadges:

Orace v/s SQL Server careers

Hi, I am newly join a job on Sql Server.Is it having good future?  I heard that Orale is more good and having good career. Please give me ur valuable suggestions.

Prcvjr220 pointsBadges:

Database files in Oracle 9i

i had installed in my PC oracle 9i. i dont have time in practice in niit instutute. i had decided i will prctice in my home but problem is i dont used database file in oracle can u tell me setting about db files

Varsha500950 pointsBadges:

Importing a “flat” field into a Lookup Table format in SQL database

    * I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated...).     * I have created a table...

Roguetexan5 pointsBadges:

“map drive” IFS

Hello, We have a ?LAN without any server Windows OS in it? , so everybody is a client (with fixed IP). The only ?server? we have, is our iSeries i5 (V5R3) with iSeries Access(CA) installed (also on the clients). We cannot ?map drive? the IFS f.e. root with \QS6555A8Aroot (or anything else on the...

Hahajokes5 pointsBadges:

Benefits/disadvantages of hosting SQL server on site versus MySQL in cloud?

What are the benefits or disadvantages of hosting a SQL server on site or using a MYSQL server in the cloud? The MYSQL box is much cheaper is there anything I will not be able to do with my web app using MYSQL?

NewnanIT1,110 pointsBadges:

Migrating from Windows server 2003 32-bit to Windows Server 2008 64-bit

We are migrating from Windows server 2003 32bit to 2008 64 bit. What should we be aware of before progressing? What pitfalls or incompatibilities should we be prepared for? The server is an Active Directory box running SQL 2005.

NewnanIT1,110 pointsBadges:

How do I INSERT records into AS400 DB2 file from SQL server?

I can pull data from AS400 to SQL but cannot get my command on the SQL server to push the data back.  This is a very small process, I only need an item number and date. Also, the date on the SQL db is "datetime".  I'll need to convert that to a more recognizable date field to put in the AS400...

Normap2275 pointsBadges:

Connecting VC6 to SQL server

how can i connect VC++6 MFC application to SQL server? plz help m out!! :(

Munazza5 pointsBadges:

SQL Server error 7125: Updated driver to get around?

I have used Microsoft ODBC SQL Server Driver to create a link to an SQL table using Microsoft Access. The table stores Word documents. However Access will not save records once large pictures are added to the Word document (thus increasing the size of the document). The following error occurs:...

Health2u5 pointsBadges:

Using Excel 2010 to pull data from SQL Server?

How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.

NewnanIT1,110 pointsBadges:

Cannot forward events from SQL Server 2005

I'm trying to forward events from SQL Server 2005 SP3 to a different server, but the only server I can select is the local server.  What must I do to see other servers in the Event Forwarding Server drop-down box?

Bmajor5 pointsBadges:

Documenting stored procedure jobs in SQL 2005 enterprise

Our consultant created several stored procedure jobs within SQL 2005 enterprise. How can we view them to document them? SQL runs on a Windows 2008 box with 32gb of memory.

TeachMeIT975 pointsBadges:

Can’t log in after upgrading SQL Server 2005 express to SQL 2005 standard

I have upgraded SQL Server Express 2005 to Standard 2005. Every thing is updated and all Services are well running, But not able to login because I have got only Configuration Tools in Menu- Start->Programs->MSS 2005->Configuration Tools. and if I try through Run SQLWB,it's shows not...

SQL815 pointsBadges:

IT Book Giveaway: Oracle Solaris Cluster Essentials

We've got your ultimate in-depth resource on the start-to-finish lifecycle guidance for planning, implementation, management and troubleshooting your Oracle Solaris Cluster. There's even helpful advice for both Oracle and non-Oracle database environments. Win this valuable resource by answering one...

MelanieYarbrough6,345 pointsBadges:

Improve performance on Insert rows into DB2 400 table from SQL server

Using INSERT OPENQUERY and a linked server on SQL Svr 2005, to insert rows to DB2 table on AS400. To a local AS400 runs very quickly. Performance on a remote 400 is very slow, and seems to be out of proportion to the change in line speed. Is there anyway to improve the performance for Inserts to...

Code2live55 pointsBadges:

SQL SERVER 2005 Database Options

We have a database in production that is 500GB, what are the pros and cons for setting the "Page Verify" option to "NONE" on the database for best performance? How will "TORN_PAGE_DETECTION" and "CHECKSUM" affect performance?

Rick Martinez585 pointsBadges:

Extracting in SQL Server 2005

IS THERE ANY WAY TO EXTRACT FROM A FIED EXAMPLE: I HAVE A ADDRESS LINE AS 1065 VALLEY LANE APT 120                                                       SCHAUMBURG...

Hydrostani20 pointsBadges:

ESXi v4.1 White Box

I'm looking to put together a server to run ESXi v4.1.  I've selected the following hardware components and would appreciate any advice/input good/bad:  Case: Athena Power CA-SWH02BH7  Mobo: TYAN S8230GM4NR-DL  PSU: Athena Power AP-P4ATXK110FEP  CPU: AMD Opteron 6134 Magny-Cours 2.3GHz  64gig...

DaveMPA55 pointsBadges: