• Is it possible on iSeries that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used.

    Is it possible on i series that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used. We had an issue wherein an entire library had to be cleared and all files from had to be restored from a previous backup, after the backup was...

    JohnsonMumbai1,160 pointsBadges:
  • Count IIF Statement?

    In the design of a query, I noticed that under the tab "Group By", there are only a few types of commands to make calculations. For example, the commands include Sum, Avg, Min, Max, Count, StDev, Var, First, Last, Expression, Where. Is it possible to have a special command? I'd like to use...

    Twj21025 pointsBadges:
  • using SQL statements…………..

    Hi All, I have a problem. I have a string variable STR which contains SQL statements...... Like insert into lib1/fil1 select * from lib2/fil2 variable STR is changable...means I update the values of library and files at run time...in the variable STR.. I want to execute the SQL statements contained...

    navinnegi45 pointsBadges:
  • generating a custom database from an existing database

    from a excel database with say 300 names, I would like to click a button to choose the names and quantities to generate a custom vdp database.

    LVNEONCOWBOY211215 pointsBadges:
  • Hibernate with clob type

    I am using clob of oracle 10 g in hibernate. When i tried to insert 5000lines of HTML code to the variable in jave, i am getting the following error; Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.citi.gicap.bpm.ver.domain.Notes];...

    Arunpmk5 pointsBadges:
  • Report / File repository for AS/400 V5R4

    Currently we have a home grown web application where we send our reports from the AS400 so our clients can view them. They are converted into a Monarch format. We would like to replace this with something else. We need to be able to put out .csv files, .pbf files and other types in addition to just...

    CharlieBrowne39,815 pointsBadges:
  • How to use “Program-Described-File” for converting an AS/400 numeric field into Char-field

    My situation is..... I have a file which is old & got 18,000 records in it. It has a numeric-field(Amount, Len 9,2). Now the 'Amount'Field in the file is changed to 12-char, in the new library. only this field's name is changed in order to avoid ambiguity. Otherwise the file-name & other fields...

    svankipu560 pointsBadges:
  • SQL Errr

    Hi I am a novice to SQL and I was hoping someone can tell me where I'm going wrong. I have a small sql statement that keeps giving me an error message. Can any one help please. Thank you in advance. Dawn > UPDATE AMFLIBT.MOROUT SET OPSTC = 40 WHERE (select AMFLIBT.MOROUT.ORDNO,...

    Dawn81600 pointsBadges:
  • Create QA database with only some production tables

    I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They're all in the same filegroup in the original database. I've...

    Rwaltz5 pointsBadges:
  • Generate binary dataset after weighing cases in SPSS

    Hi, I have some variables that are of binary format (0,1) and of which I produce cross-tabs. In the case that there is a weighted variable, SPSS "imputes" some of the values "weighting" them either as (0) or (1). However, there is no way to know which values have been replaced (I cannot find any of...

    Polyc5 pointsBadges:
  • Dynamically Add Picture Control in a window in PowerBuilder

    Good day, In PowerBuilder, how can I add a picture control on a specific location on a window progmatically or at runtime...?  thanks.

    Bogus215 pointsBadges:
  • Access or SQL Server tables

    Yes I am consultant for a small business, and currently they have a Access database that works pretty decently. At the current situation, the owner needs another database. I really do not want to have to ask the developer to keep creating different databases that includes him having to put more...

    Imjnice15 pointsBadges:
  • Extended ACL

    How do I create an ACL for: Allow inbound HTTP requests to the www.yzcorp server. Add info: The www.yzcorp.com website at 10.0.1.2 is registered with the public DNS system at IP address 209.165.200.246       permit tcp any 209.165.200.246 eq www is not working.

    IFOY50 pointsBadges:
  • about visual basic.net

    Hi I install vb.net ready and make connection ready, but when I try to using SQL statement it is error: my SQL is dim strSQL as string="select * from tblCustome where CustomerID="& intCustomerID the error is it does not no the string &? Please show me the solution how to solve this error! thank my...

    000015 pointsBadges:
  • updating, deleting in access with asp.net using Visual basic

    hi, i m using  asp.net 2005 usin vb. i m having gridcontrol with the back end of msaccess.  i know to retrive the data from databse by using tis code, Dim msaccessconnect, query, databasecommunication, readdatabase         msaccessconnect = New...

    Priyadharsini5 pointsBadges:
  • bmail to send mail to an exchange server

    Hello, I want to run bmail from the command prompt to send a mail.I am using exchange sever 2003 as as the mail server,when ever i enter the script it tells me that socket closed.Plz can any one help..

    Bsanneh30 pointsBadges:
  • Combining Access 2003 Queries for Dates Criteria

    I have a MainInfo table and 3 different Log tables (PleadingsLog, LitigationLog and DiscoveryLog) that are linked to the MainInfo table by an IDnumber. Each of the log tables contains a date field and a notes field. I am trying to find a way to query all records from the MainInfo table that show a...

    GCIB15 pointsBadges:
  • Software application to build database

    I'm Planning to build an application to store/update and retrieve data (say employee details) Could you please suggest me the best frontend and backend technologies to build this application?

    Serenechennai5 pointsBadges:
  • How to create data security in SQL server 2005 so that the code will not be opened

    how to create data security in sql server 2005 so that the code will not be opened

    Gkhlhlhjhhghgg15 pointsBadges:
  • How to remove the double quotes in CSV file in iSeries

    Hi The command is to remove the double quotes present in CSV file. I have used one shell command. Strqsh cmd(Sed -e 's/""//g' file name > new file name) I have to write this command in CLLE program. CHGVAR     VAR(&RPLC) VALUE('Sed' *BCAT '-e' *BCAT +                 ...

    iiiiiiiiiiiii335 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