• Question on JOIN Clause

    Folks, Is there any differences between selecting values from a table using JOIN clause, by using as JOIN or INNER JOIN. I mean, Will the result or performance changes when JOIN is used instead of INNER JOIN in MS SQL SERVER 2000/2005 Thanks in advance ! ash

    Ashok tak0 pointsBadges:
  • update single row error

    This query returns a single row error while attempting to update the mfr_name_id in the property table with the values in the eqp_mfr_names table where property.mfrcode = eqp_mfr_names.mfr_code why? UPDATE property p SET (mfr_name_id ) = ( SELECT (mfr_name_id) FROM eqp_mfr_names WHERE mfr_code =...

    Mandrews810 pointsBadges:
  • Select from table where data row missing

    I have a table with the main fields being BU, ASSET, BOOK for any BU and ASSET combination, there should be two to four rows of data, with just the BOOK value being different. Data corruption has caused us to find all BU-ASSET combinations missing the value 'AMT' for BOOK. I need to join the table...

    Jej12160 pointsBadges:
  • Open MSAccess database

    Hi there, Does anyone know how I can open an Access database with script without giving the path of the MSAccess.exe file. I would need the equivalent of Execute, @Command that does not require a path. @Command( [Execute] ; "msaccess.exe"; "C:\\MyApps\Test.mdb" ) currently I am using Shell that...

    Constantin0 pointsBadges:
  • what is VOW in terms of DB server

    what is VOW in terms of DB server

    Subha0 pointsBadges:
  • Data Sync in tow tables

    We are in the progress of restructing the old database. In this effort , we are joining data from 3 files files and creating a new schema. in the process of migration , we need to keep the new file and the old files in sync. How do we achive this? I was planning for triggers on Old file and the New...

    Uiiuo50 pointsBadges:
  • Backward compatibility on OS level V4R4 to V4R3

    Have a question on backward compatability. Currently we moved some historical JD Edwards data that was on an AS/400 running OS400 V4R5 to a machine running V4R4. Now, we want to move this to another AS/400 that is running V4R3. Now, from V4R5 to V4R4 we havd no problems. I'm not sure if we can take...

    Sysop0 pointsBadges:
  • Synchronizing Two Subforms in MS Access

    In my main form I have two tabs – Alumni Class and Placement – both of which tie to the AlumniClass and Placement tables respectively. My Alumni Class subform stores the year and term a person graduated. My Placement subform tracks if the person was offered a job (company name & position) for...

    FERREJE0 pointsBadges:
  • SQL joins on encrypted data

    Hi - we are in the process of encrypting various pieces of sensitive information in our SQL 2000 tables. For many fields we are using Blowfish 448 encryption and a concern has arisen about inline SQL statements that contain joins in our ASP scripts. Are there any scenarios that you have run across...

    Tombstone7770 pointsBadges:
  • I can update the dataset, but not the database

    Posted on behalf of BodjorB: I have been trying to update a database in a program i developed using Microsft Visual Basic 2005,SQL Express -- whenever I enter data and click on Update, this updates the dataset, but the database is not updated. What am I forgetting?

    Margaret Rouse1,210 pointsBadges:
  • ASE 12.5.4 disable printing of column headings

    How can I suppress the printing of column headings while using isql (command line utility provided by Sybase ASE)? without using and sed filter commands. I cannot use -b flag coz the isql utility that I have on my machine doesnot have -b flag.

    Dips0 pointsBadges:
  • Tracking Changes to Files

    Requirement:- To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee) Could you please suggest a good approach for this? I am currently using the approach of journalling. 1. Both A and B are journalled. 2. If Any changes...

    AyeYes4000 pointsBadges:
  • odbc access error…….

    Hi, a company send their information for us,it was a zip file that contains a ms access database file and a simple exe file,when I have administrative right on computer when I run exe file,a form was opend and I can see data,but when a power user open it an error was appear :...

    Aliyani265 pointsBadges:
  • Excel Data Transfer Add In

    I tried transferring data from a physical file (AS400) using the Excel Data Transfer Add In (Client Access) and am getting cells with unreadable syntax. It appears that a space is being populated with a 4040 string etc. Is there a way to get the information transferred without having to modify the...

    Joe9250610 pointsBadges:
  • URGENT!!! file field decoder generated on AS/400

    REALLY URGENT!!!!!!!!!!!!!!!!!!!!! How can i view the contents of a packaged field? I send an example of the chain. I need to visualize the contents of the little squares: 5 1 91010 491997 9801011L 980101 1 1021023 102 103 100 DTO CARULLA DTO CARULLA DTO CARULLA 0 1 0 11 K 1TQ 15% Q TQ NAL T TQ NAL...

    Onasis0 pointsBadges:
  • computer protection with revert

    I am looking for a solution wich will allow me to revert computers setting back to original each time computer reboots. Basically on reboot computer will earse all files and configurations made in previous session.

    Dimchik0 pointsBadges:
  • outer join issue

    Following occurs in a cursor is plsql block: I have 3 tables: Source (name) Lookupmap (name, lookupname) Lookup (lookupname) I have to: 1)outer join Source and LookupMap based on NAME in order to validate that NAME actually exists in Lookupmap. If NAME in LookupMap is null then I have to provide a...

    Hosrow0 pointsBadges:
  • Error in a Group of Called Programs

    Hi, I have a CL program, it calls 10 other programs i.e. pgmA, pgmB, pgmC.......so on...10 programs. While running the CL program error occurred in pgmC. I rectified that error. After rectification once again I will run the CL Program. Now my execution must start from pgmC. How do i do this???...

    0 pointsBadges:
  • media recovery

    Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....

    Sukaina10 pointsBadges:
  • Question on Workfile

    Hi, Please could any one help me getting answers to these Questions.... What is the diff. between Workfile and PF? How do u create a WorkFile in RPG or CL. What are the advantages of WorkFile over PF? Thanks Rama

    0 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