• How to keep whitespace in datagrid

    I have a simple .NET app. You key a SQL statement into a text box. It then connects to any one of 5 i-Series and returns a datagrid. I am curious as to how I can preserve the whitespace in the columns. These columns have some fields with data right and left justified. Other fields a large field...

    ToddN20008,705 pointsBadges:
  • Execute SQL statement using an RPG variable

    I'm trying to pass a cursor and data structure to a procedure. That procedure should populate the structure with the next row from a SQL cursor. Here's what I'm trying to do: ***************************************************** * * Fetch the next row from a cursor * * @param cursor - the name of...

    ITKE342,860 pointsBadges:
  • Using NOLOCK in SQL Statement (SQL Server 2008)

    This is more a general question but a friend of mine is in the business of making websites and applications that aren't mission critical. So with that, is it bad practice to use the NOLOCK hint in SQL Statements? He was told by an SQL administrator that he should use it if he's satisfied with a...

    ITKE342,860 pointsBadges:
  • SQL query help – SQL Server

    Okay, I hope I can explain my dilemma... I need a SQL select statement that will Select part_number from RCTOOL the column part_number has values such as BR643-0034-344-34 AS54-54689 A77360-3454-34456-4 B7374-343-33-32-356-433-11-1 In each of these cases ALL we want it to return is the values UP to...

    MyDanes35 pointsBadges:
  • AS/400 – SQL

    I am reading a record in SQL with No Lock and its getting displayed in Screen. Based on the user input, I will/won't update the record. I want to check the record lock before performing the update statement. I don't want to check the SQL code after performing the update statement. What I want is: I...

    rajeshece1,215 pointsBadges:
  • SQL creating an unwanted duplicate of file

    The other day a colleague ran an SQL statement to update a field in a file to a constant where 2 other fields were equal to constants (so no joining was needed, etc.) When finished, there was a duplicate copy of the file in the first library in the library list. (Which is higher than the library of...

    BigKat7,935 pointsBadges:
  • SQL Plus stops before finishing

    Why does SQL+ stop after running so many characters in a long SQL statement?

    rayfish201315 pointsBadges:
  • iSeries SQL Cobol

    In my COBOL SQL select statement that was previously running on V5R4, I was able to extract a date field defined with "date" as the data type. We are now on V7R1 and we get a data mapping error. No clue as to why? Any ideas? thanks

    Pgmr4655 pointsBadges:
  • Lost my SQL log

    SQL statements from a session (first session) have been lost because I opened a second SQL session and saved this when exiting AFTER exiting my first session. So, when I STRSQL, I only see the statements from my second session, those from the first session are gone. Can I somehow retrieve the...

    usuala20 pointsBadges:
  • Stored procedures

    What is meant by stored procedures? What is purpose of them and where can we use this stored procedure? Can any one provide the information regarding this? Thanks in advance.

    ravula700 pointsBadges:
  • DFU to SQL translator

    Is there a package that will allow the user to enter DFU commands and then translate to SQL and send that to the processor? The situation is that the logging program doesn't see DFU commands but does see SQL statements.

    DandyDon10 pointsBadges:
  • Using cursor in SQLRPGLE

    Can i use single cursor for multiple SQL statements? ex:  declare c1 cursor for select * from ....... also declare c1 cursor for select * from xxx

    varad40 pointsBadges:
  • I have a family tree and want to total all wealth for the entire family tree for any selected family member

    I have a database of a family tree of several separate families. Family of Joe smith, family of John Jones. etc. some families have only 1 member others have hundreds of children, grandchildren, great-grandchildren, etc. John Jones had no children so he is a family of 1 John smith had 2 children...

    3dJoe10 pointsBadges:
  • Long time to run the select SQL statement for Mimix Jornualed file

    Hi Guys, I want to know why it need very long long time to run a select SQL statement on Mimix jornualed files. It ran over 3 days for a select statements on a MimixJrn files (over 1 Millians records). But only use less than 1 hour to complete the same SQL selection statement for Non-MimixJrn files...

    MimixJrn20 pointsBadges:
  • Transform rows to files in an SQL statement.

    Hello We hava been able to produce the SQL that returns us a Vertical table with the LABELTEXT  from table CLIENTES (sql against qsys2/syscolumns).   SELECT LABELTEXT FROM QSYS2.SYSCOLUMNS WHERE TABLE_NAME = 'CLIENTES' AND TABLE_SCHEMA = 'MANEL' Observe vertical orientation. Column 1 Column 2...

    I40075 pointsBadges:
  • sql statement…..

    Can someone take a look at this code and please tell me what i am doing wrong? SQL> INSERT INTO "CDAAS"."INFORMATION"   2  VALUES ('MBedfo','Maurice','Bedford','Maurice Bedford','','','02/02/1990','1234','','',''); VALUES ('MBedfo','Maurice','Bedford','Maurice...

    Wdoss5 pointsBadges:
  • SQL statement needed to remove characters

    I have data in one of my columns in a table that I would like to remove via a SQL update statement.  In all cases, the data that I want to remove is the same 3 characters at the end of the varchar field.   How would I structure the SQL statement?

    Satonthehill5 pointsBadges:
  • SQL Update Set: Higlight Customers without Invoices, Update and join Tables?

    Hello, I am not sure how to do this with an SQL Update Set statemet: I have a table customers and I have related invoices. I would like to set one field to "not active" in the customer table that did not receive invoices since 2008. I can "Select" the corresponding records in the customer table...

    Cavallino30 pointsBadges:
  • SQLRPGLE Error in UPDATE Query

    Hello, I have a SQL Statement in SQLRPGLE which Updates a 3 fiels in a file with 30 fields. SQL Statement is as below. UPDATE TABLE1 SET TXDATE = :SYSDATE, TXTIME = :SYSTIME, SETFLAG = :w_Set, MSG = :w_ERR, Comment = ' ' WHERE ID = :W_ID This works fine on one iSeries server and throws...

    sim400305 pointsBadges:
  • Select statement in asp.net

    How can i use ms sql select statement with where clause in asp.net

    Pioneerinaspnet15 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