• Oracle SQL question

    I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I'm unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case statements but Oracle doesn't like...

    Wanderer95775 pointsBadges:
  • Multiple Tables to Bulk Import .sql script

    I am a very new user to both SQL and Oracle and I am hoping that someone can explain to me if there is a way to multiple tables in a schema to .sql Import scripts. I know that in TOAD, you can right click on a table and choose export from the list, then save it as an .sql file. If I select multiple...

    ADMIntegrated5 pointsBadges:
  • Unique ID for existing table

    I want to add a column to an existing table where its values should be unique and auto generated in a sequential order

    Ragas60 pointsBadges:
  • SQLRPG MaTERIAL

    I got a task to work on SQLRPG programmes , but I am very new to this environment . Can any one send me any link about : SQL-RPG . I need from scratch. Thanks in Advance.

    Khadar90 pointsBadges:
  • SQL in an SQLRPGLE program

    I want to use embedded SQL in an SQLRPGLE program to search a file for a field entered in a screen to select data using the LIKE operand. This is my code C/EXEC SQL C+ DECLARE C1 CURSOR FOR SELECT * FROM F0101JN WHERE ALADDZ = :SZIP C+ AND ABALPH LIKE :SINNME ORDER BY ABAN8 C/END-EXEC * I entered...

    Alpfalpf25 pointsBadges:
  • How to config iSQL Plus on computer without a domain

    Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message "The server encountered an internal error or misconfiguration and was unable to complete your...

    DerrickOra5 pointsBadges:
  • Local Security for Vista Home Premium – Network Access

    Hi there Vista Home Premium - I've been trying to configure the local security option for Network Access - sharing and security model for local accounts, to 'Classic - local users authenticate as themselves'. This PC communicates with another where an account has been created ( user and password...

    Gratch5 pointsBadges:
  • SQL 2008 Identity column values 0

    We recently migrated our application from sql 2005(32 bit) to sql 2008(64 bit). I have observed that one of our tables with an identity column is now having all values are 0. I am yet to find out the reason .Could this be related to migration??

    Swetaleena5 pointsBadges:
  • Does something similar to Oracle’s optimizer hints exist in SQL Server ?

    In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc... Does something similar exist in Microsoft Sql Server ?

    carlosdl65,110 pointsBadges:
  • how to capture cases in store procedure codes

    I wish to creat a query in store procedure (with variables such as Start Datetime, End Datetime, Parameter varchar(3) as you can see on my store procedure for other reports). But for this report, I wish to capture a case might fall into one of the columns (only one column such as DECLEAREDDATE OR...

    Josephptran15 pointsBadges:
  • spool to flat file from SQL editor

    I am using SQuirel SQL to execute queries against an AS400. I need to be able to execute a series of queries and export the results to a flat file on the local client. Can someone give me the idiots guide?

    Daowebe20 pointsBadges:
  • evaluating a range

    I am trying to evaluate a formula to return a statement if true. I am having trouble with the syntax. I am working out the number of years service for staff using the formula currentdate-{employment date}/365 What I want to evaludate is whether the result is between 5 and 6. If true I want the...

    Gerrycan5 pointsBadges:
  • Updating a field and counting unique field values from another fields all in the same query?

    How can I structure the following query to allow me to count the number of unique entries in a field named "amount" and using the same query, update another field named "unique" Here is what I am doing: SQL = "select amount, count(amount) from tblmessagein group by amount having count(*) = 1" If...

    Grantp40 pointsBadges:
  • sql with windows vista home premium 32bit

    can i install sql programs in windows vista home premium 32bit

    Mayo5 pointsBadges:
  • SQL 6.5 Upgrade

    We recently upgraded an application from MS SQL 6.5 to MS SQL 2008. We took quite a performance hit. Is this to be expected?

    DickRich15 pointsBadges:
  • New CUM Level 8305 is giving me SQL Headaches

    We recently upgraded to a new machine at OS Level V5R4 CUM 8305. Our old machine was also at V5R4 but the CUM level was only 8057. Ever since the upgrade, I have been having SQL Problems. My latest problem involves trying to update a QTEMP File that was built using CRTPF and specifying a record...

    FCARPENTER200 pointsBadges:
  • How do I write a SQL statement to get all data from a table called subscrib?

    How do I write a SQL statement to get all data from a table called subscrib?

    Thechriseco5 pointsBadges:
  • Store Procedure Codes Please help

    I have a problem in SQL, and please expert helps me out and give me an advice of how to solve this issue. I have a main table where to store the data, I have mutliple columns and those are SSN, DECLEAREDDATE, SOMATICMCCLEAREDDATE, PSYCMCCLEAREDDATE, DESECONDCLEAREDDATE, SOMATICMCCLEAREDDATE,...

    Josephptran15 pointsBadges:
  • Matching External lists to your Database?

    Hello everyone, I work in a telco and manage the data in the company's CRM. I'm often given lists of company names by our alliance team, and asked to match the list against our database to see which companies already exist in the CRM and which don't. At the moment I can only accomplish this by...

    Nik145 pointsBadges:
  • SQL Writer library failed initialization

    SQL Writer library failed initialization. Your installattion iseither corrupt or has been tampered with. Please uninstall then re-run setupto correct this problem. How should I handle this?

    Valeverger10 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