• How to create Dynamic DDS for a PF(Physical File In AS/400)

    How to create Dynamic DDS for a PF(Physical File In AS/400)

    Ugan5 pointsBadges:
  • Community Update: New Member Contest Win a XBox 360 this month for your participation.

    After a long, stressful day in IT, video games can be a great way to unwind and relax. That’s right, you know where this is leading. It’s time for a cool new contest on IT Knowledge Exchange. The month of September ( Sept 1-Sept 30) is your chance to get your hot little hands on your very own...

    ITKE341,970 pointsBadges:
  • Sum Values Of A Particular Column In A Tilde Delimited File on Solaris

    Hello All: I need to sum the values in the 3rd column in my tilde delimited file on Soalris. Is there any command that will let me do this? Thanks

    Gchahl25 pointsBadges:
  • converting files Lotus to Microsoft

    Our church office has used Lotus Approach 97 for the mailing list. We have about 600 names. Now we are converting to MS office 2007 and using Access. My question is, can I convert the Approch files to Access - my secretary really does not want to retype all of the address unless necessary. Thanks...

    Preacher2335 pointsBadges:
  • Access 2007 Complex Calculations

    In Access 2007 I need to enter raw test data into tables, perform complex calculations including linear trends, then store the calculated results. These are the only numbers I really care about. The raw test data could be deleted for all I care, I just need the calculated results. I will need to...

    Ryanwd10 pointsBadges:
  • Adding prefix to records

    Hi, I have a simple database for some products that has some SKU numbers... ie SKU 1001-01076-0000 1001-01120 1001-01120-2100 1001-01120-2400 1001-01121 1001-01121-2100 What I want to do is add the prefix "GF-" in front of those SKUs. This is a database that will continually get sent to me, so...

    Whoshanh5 pointsBadges:
  • parallel port

    now there is no parallel port in the system and having only USB. how we can print through USB from Foxprox 2.6 for DOS. pls help me.

    Anjalimanoj25 pointsBadges:
  • AS400-DML

    I have created one table using CREATE TABLE Command and have added some datas in that table.i have defined that table RPGLE's File specification. FEmployee IF A E Disk . While compiling i am getting RNF2109 Error. Please help me to rectify this error?

    rajeshece1,215 pointsBadges:
  • Error message during database mirroring on SQL Server 2005

    I am trying to begin database mirroring in SQL Server 2005. I have Service Pack 2 installed, and I have three instances running. When I attempt to start mirroring, I receive the error message, “One or more of the server network addresses lacks a fully qualified domain name.” My network...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Export from Access to Excel shifts decimal position randomly

    I am exporting from MS Access '03 to MS Excel '03. I retrieve several columns formatted as Fixed width with 2 decimal places in a query and then export those results to Excel. Occasionally, some of the columns, but not all values in that column, will display with the decimal point shifted one...

    MBachman5 pointsBadges:
  • Problems with tranferring flat file from mainframe to Outlook as CSV file

    I am trying to e-mail a plain text comma delimited flat file from the mainfram to Outlook. I have the coding working to transfer the file but when the file arrives in outlook the first character on each line is an '&'. When EXCEL trys to open the file it generates an error message that this is an...

    Rickb19745 pointsBadges:
  • error in DB2/400

    Hi, i created a physical file(named 'PHF1') and created a logical file(named 'LF1') in Source file(named 'MYSRC')..i complied those files and inserted data.. i wrote a query by STRSQL,that query is "SELECT * FROM LF1"...But i getting a error as "LF1 in *LIBL type *FILE not found" NOTE: I'm using...

    Nayak5 pointsBadges:
  • Union Query

    I 've a problem with porting my ms access database to sql server. In my inventory database, i have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, i do with this kind of queries : a....

    Ipong40 pointsBadges:
  • Compile Error

    I am trying to prevent duplicate job orders from being entered for the same employer. The employer is in the main form and the job order is in the subform. I have this code attached to the "beforeupdate" event of the control on the subform but I get a compile error: wrong number or arguments or...

    Bec10 pointsBadges:
  • Can you help with the following DAO code explaining a step-by-step process?

    I’ve had some exposure to VBA and know the Access Interface very well (Microsoft Certified). I purchased MS Access 2007 Programming By Example by Julitta Korol a couple of months ago and all of the hands-on examples display the results in the Immediate window or a msgBox. Although I was able to...

    Doc3310 pointsBadges:
  • Add module to remote access database

    I have 100+ access 2000 .mdb's that I need to add a specific module to. What I want to do is loop through all mdb files in a specific directory and add a standard module to each one. Any ideas as to how to accomplish this from within access vba would be appreciated. I intend to do this from within...

    Ttstudio45 pointsBadges:
  • Access databases

    I have a database that is in Access, Does anyone know if it is possible to query this DB using SQL server 2000..?

    Michaelrdowney10 pointsBadges:
  • DML

    What is DML.How to use DML in AS400. What is the advantage of using it?

    rajeshece1,215 pointsBadges:
  • DTS of TEXT to BLOB or CLOB

    Is there a maximum size to DTS from text to a Blob or clob ?

    Donranny5 pointsBadges:
  • Actuate 8 enterprise reporting tool,Text files

    Hello, Am currently using actuate 8 as a reporting tool.The major problem encountered is to deal with flat files with fields separated with other delimiters other than commas.For example I encountered a flat file delimited with back slash am unable to tackle.Is there any way out in Actuate 8 or...

    Ingosi10 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