• SQL update a column to remove a certain character

    I have a table (book) where there is a column that contains number in some rows and numbers with an addition *infront. I want to be able to perform some calculation with the table but the '*' is preventing me from doing this. So how do I update or alter the table so that I can remove the * and keep...

    Lazy16755 pointsBadges:
  • Excel report from RPG or SQL

    How do I produce an excel report via RPG or SQL inside an RPG program?

    Taborly0820 pointsBadges:
  • Extracting data from a long column data

    I have a table which contains the swift messages in a long column<COL1> in one of the tables<TAB1>.In the long data there is some field data starting with 121: <>.I have to read through the long data and find whatever is there after 121: .Plsql or SQL any solution will do .

    Barun2285 pointsBadges:
  • DOT NET SQL CONNECTION TIME OUT PROBLEM

    IN MY SQL CONNECTION STRING I WAS MENTION CONNECTION TIME OUT IS 500. MY SQL PROCEDURE WAS RUNNING 45 SECONDS ONLY IN QUERY ANALYZER. ITS RUN ON DOT NET PROGRAM THEN CONNETION TIME OUT ERROR WAS COMMING.

    KonguKarna5 pointsBadges:
  • Update sql400

    What is wrong in this statement

    Msatbh190 pointsBadges:
  • Recover corrupted SQL log file

    From a few days, I am not able to access my SQL log files. Is there any corruption in these? I am not able to figure out. Please suggest some measures.

    ankit33022,060 pointsBadges:
  • Corrupted MDF files

    Can anyone help me with how to view corrupted mdf files? I have certain MDF files which have been corrupted and creating hindrance in accessing SQL server database. I want to view these files. So, just wanted to know how to view them?

    ankit33022,060 pointsBadges:
  • Arabic characters not displayed during SQL using IBM Navigator for i

    I have a table on the IBM i DB2/400 database, table CCSID is 420 = Arabic. My user profile is configured to CCSID 420 also. My 5250 green screen session is also configured to use CCSID 420 and my keyboard is configured to be able to enter Arabic characters. I enter Arabic characters on one of the...

    Jpjawili290 pointsBadges:
  • Error in compiling embedded SQLRPGLE in full free format

    Hi everyone - here's a question from a user in regards to SQLRPGLE: I have written some simple embedded SQL PGMS in COBOL in AS/400, compiled and run successfully. But I am not able to do so in full free format RPGLE. Here is the RPGLE code that doesn't compile. dcl-s sql_RCONAME char(20) ; exec...

    Michael Tidmarsh65,595 pointsBadges:
  • Virtualising SQL Server

    How much of this article is still applicable with the advances that Virtualisation Technology has made? https://searchsqlserver.techtarget.com/tip/SQL-Server-virtualization-not-always-a-good-idea I am asking as I have a client that has quoted this article to justify why they  should not virtualise...

    timjee5 pointsBadges:
  • Regarding Oracle connectivity issues

    I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the...

    Vabene0 pointsBadges:
  • SQL Report Help

    Hi I'm dave and I'm new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return based...

    Blowinup5 pointsBadges:
  • Create table dynamic SQL using SQLRPGLE

    Hi. How can I create table using dynamic SQL using SQLRPGLE?

    amiruladli9540 pointsBadges:
  • Post SAP DB2 Refresh

    SAP Post refresh DB2, we get this dump always for every T code when ever it hits new Virtual table: Database error text: "SQL message: DbSlModifyDB6: Virtual table ASPART_CONF is not owned by current connect user." I hit the transfer owner command and it is resolved but again new issue arises with...

    FAYZAN5 pointsBadges:
  • AWS Testing tools, must support Unix (Scripting) and DB (validations)

    What are the AWS testing tools, which supports: Unix shell scripts Post GRE SQL (for data validations)

    sainaths5 pointsBadges:
  • Make SHA hash value in SQL on AS/400

    How can I make a SHA hash value in SQL on AS/400?

    nadineha5 pointsBadges:
  • Change data page in the memory for MS SQL UPDATE

    How can I change the data page in the memory is written to LOG FILE in the disk?

    sisaygebre2910 pointsBadges:
  • SQL database page level corruption

    Hello Experts, We are facing page level corruption in SQL database. The database size is 650 GB. What should we do?

    DBAPriya30 pointsBadges:
  • Starting a career as SQL database developer

    I recently have finished my btech 3rd yr via cse. I am quite interested in SQL so I want to be a SQL database developer. So please guide me in what other languages I should learn and what other skills I should learn too.

    Rajiv62535 pointsBadges:
  • Looping using READ vs Embedded SQL

    Which approach is better? What all the parameters, we need to consider to come to a proper conclusion? Which approach is better in which scenario? Can anyone explain in detail?

    xselvam20 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.

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

Following