• AS400 RUNSQLSTM – Problem with CAST

    I am using a RUNSQLSTM to insert records from file A into file B. One of the fiels in defined as 4S 0 in file A and as 4A in file B. If the value in file A is zero, not matter what I have tried file B gets populated with a 0 followed by 3 blanks. I need to be '0000'

    CharlieBrowne41,380 pointsBadges:
  • Linking Access to SQL Server

    Hi ive got alot of linking tables in Ms Access and I want to link in onto Sql Server 2005.how to i do the liking part

    Ilse5 pointsBadges:
  • Can ACCESS forms be used in EXCEL?

    Can forms created in ACCESS be used in EXCEL (via VBA)

    Jgenterprises10 pointsBadges:
  • Why aren’t the Crystal Reports indexes showing since loading V6R1?

    I use Crystal reports via ODBC to the iSeries and have for years.  After loading V6R1 when I go in to create a report, the files aren't showing any indexes like they used to.  The used to show indexes based on the file definitions but now there are no indexes showing. I have even pointed the ODBC...

    DHardy5 pointsBadges:
  • Free IT Book: Why New Systems Fail

    This week's free IT book is Phil Simon's Why New Systems Fail: An Insider's Guide to Successful IT Projects. Simon provides the necessary framework to "minimize the chance of system failure before, during, and after beginning IT projects." Win this book for some real-world and specific tips, tools...

    MelanieYarbrough6,345 pointsBadges:
  • Copy Table in SQLPLUS

    How to copy a table from an access database using sqlplus

    VB and Access5 pointsBadges:
  • Oracle 10g database creation errors in windows 7

    hello friends this is avishek behera.. recently i installed oracle 10g database software only in windows 7. after that i tried to create a database.. but i got an error like oermission denied.. i have installed in d drive which is not my system drive and also installed with administrator previlage...

    Avioracle15 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:
  • Old Recovering Access database password

    A client of mine worked on a database 5 years ago for a research project, but she had to quit for a while for cancer treatments. She's now responded well enough to go back to the project but her database, done probably in Access 2003 (perhaps even an earlier version, but certainly not a later one)...

    KyleFreeman130 pointsBadges:
  • Transform DB2 to XML from AS/400

    I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client's web server. I have looked at IBM's XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something...

    LBurkett99830 pointsBadges:
  • Recommend a Simple Data Input & Editing Tool

    [strong]Please[/strong] recommend a simple to use data input, text editing tool that will create a "flat file" with data fields that are in specific starting positions of the flat file.

    Tljamison10 pointsBadges:
  • Put date time into 15 interval value in MySQL

    does any one know if mysql have a function where I can convert datetime value into : 15 mins interval for example : 03NOV2010:00:00:02 --> 0-15 03NOV2010:00:16:02 --> 15-30

    Iamjeannie30 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:
  • Access 2000 Database Entry Question

    When creating a table is there a way to set the first entry as a drop down menu and the associated entry as a currency entry on the same line? We are trying for an employee database that has several extra jobs that we would like in a drop down menu and then be able to associate the money that will...

    Mb732655 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:
  • Superseded PTFs.

    If there are special instructions for a superseded PTF that is not loaded or applied on your system in an ordered PTF cover letter, do you need to order the superseded PTF and follow the instructions for it before loading the PTF that will supersede it? I hope my question makes sense.

    Bkr0963c0 pointsBadges:
  • Access Control List for users allowed to access network

    Is it possible to setup an access list for allowed computers on the network and prevent others from using any network resources like internet and printers. Even with a valid username and password I want them blocked if they are not on the Access Control List.

    Troubleshooter24755 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:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following