• Embedded SQL to process ALL members

    Hi, I'm trying to get an RPG with embedded SQL to read all the members in a file. I know I used to be able to do this with an OVRDBF command with *ALL specified for the member, but this doesn't seem to work anymore. In the joblog I get a CPF4268 message which says the file has no members or is not...

    Gilly40023,730 pointsBadges:
  • Joining Tables in SQL Server

    What is the difference between Outerjoin and Left outerjoin.

    Bijaybehera2915 pointsBadges:
  • SQL Column Headings

    When I run an SQL statement the column headings I see are the field names. When any of the other members of our team run the same statement they get the field descriptions as column headings. I have compared user profiles and there are no differences. Is there some other place that this setting is...

    deniseg35 pointsBadges:
  • SQL Stored Procedure

    I need to create a stored procedure with an input parameter of member name to create an Alias, select all the data in the member then drop the Alias. This procdure wil be called by 3rd party software using an odbc connection.

    Markpg155 pointsBadges:
  • Using the SQL IN clause in SQLRPGLE

    Can I use a variable with the IN clause in an iSeries SQLRPGLE program? Can I use: WHERE CUSTID IN(:CUSTNUMS) Instead of: WHERE CUSTID IN(145,1600,352)

    PWMASI5 pointsBadges:
  • Visual Basic

    What would be the code (using regular expression) to match the page , whos title changes during runtime, but we know that it will contain the string "Welcome" in the begining of the title?

    Gaby15 pointsBadges:
  • Query 400 – SSN

    Hi all, I need to strip all but the last 4 digits of employees SSN in a file...I cannot remember what the string is!!! Can someone help? BTW, the current field has NO dashes in the SSN. Thanks in advance!! Rick

    Rmason345 pointsBadges:
  • Update a field in one table after the change on a field in another table using a trigger in SQL

    I have a WODet table and after the field "Complete" is changed to "True" I need to update my SODet table field "UD3" to "True" using a trigger in SQL where dbo.SalesOrderDetails.SalesOrderDetailID = dbo.WorkOrderDetails.SalesOrderDetailID Thank you in advance

    Tanjaatbrenlo40 pointsBadges:
  • PL/SQL: How to check that parameter is case-sensitive?

    Hi Experts how can i check the email id shud take only lower case in PL/SQL block i tried using vpos := REGEXP_LIKE(p_email_address,'[:lower:]','C'); as well vpos ;= REGEXP_LIKE(p_email_address,'[^[:lower:]]','C') But both says wrong type as error and p_email_address is a parameter of procedure and...

    Inprise610 pointsBadges:
  • Using WildCards in IIF Statement

    Hi, I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don't enter anything in the field on the form. I tried putting the following IIF statement in the Criteria:...

    RoadDust390 pointsBadges:
  • programming

    How can I make .png image function as a button in php when clicked. I tried this code but didnt work:<img src="images/log_in.png" align="middle" name="ok" /> <? $name = $_POST['name']; $pass = $_POST['password']; if (isset($_POST["ok">)) { echo"hie"; } ?> but when I click the button I...

    Azurie50 pointsBadges:
  • Specific content migration in Microsoft Office SharePoint Server

    I m trying to migrate specific contents such as "ImageList" picture library from one site to another, but i m unable to do so. can anybody help me?. i have tried content deployment option but it migrate all contents.

    Praj095 pointsBadges:
  • ALTER INDEX statement

    'ALTER INDEX ' || C_Indices.INDEX_NAME ||' REBUILD '; 'ALTER INDEX ' || C_Indices.INDEX_NAME || ' REBUILD ONLINE COMPUTE STATISTICS'; In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure. In middle of the code , i...

    Shaksing5 pointsBadges:
  • PL/SQL: How to handle OUT Parameter during INSERT

    HI Experts, I have a OUT parameter in my procedure(whihc performs INSERT data into a table),how to handle this OUT parameter (primary key of table) -- Will Insert statement inside the PL/SQL block should include this parameter or we should use SELECT stm after Insert to add this attribute ,i am...

    Inprise610 pointsBadges:
  • Creating form with combo box to enter data

    I trying to create a form in an inventory database that uses a combo box to select size and depending on the size, use a text box with the quantity and have it populate the correct size field. If I am way off base, please suggest alternative.

    Cecee5 pointsBadges:
  • Passing Parameters in Access into Vb6.0

    How to pass Parameters in MS Access into Vb 6.0 and get the results through ado recordset

    Bijaybehera2915 pointsBadges:
  • Create Alias In Rexx

    I am trying to execute the sql create alias in a rexx source however it fails with sql error 901, have tried command manually & works fine

    Markpg155 pointsBadges:
  • WPF and C# (challenge)

    please follow the link : "http://msdn.microsoft.com/hi-in/default.aspx" and see in the top right corner, when u move mouse over the "microsoft.com" you can find the dropdown window which grows like some animation part and when you mouse leave the animation shrinks and disappears, i want to do that...

    Vinothkumar12415 pointsBadges:
  • Microsoft Access database too large – Can I divide my Access file?

    Im new to access and have been given a task to compile a data base, which i have very nearly completed, Im in the military and using a PC networked into a military system. However i found out whilst compiling the Database the system has many limitations, the Document has got to 1.99 GB now and will...

    Ukmale5 pointsBadges:
  • photoshop in cpp

    what is the code to impiement photoshop software in c++ language?

    13195 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