• How to keep date format when creating Index on a Table

    I have used CREATE TABLE to create a PF which contain a DATE field. And then use CREATE INDEX to create a LF with data selections. However, when I check the DATE field, I find that, in the PF, its Date Format is *ISO; but in the LF, its Date Format has been changed to *DMY. How could I keep the...

    MacroJ20 pointsBadges:
  • I would like to know the code to do a “if file exist then” in visual basic.

    for some reason the first time I posted this it only showd some of it, so I've reposted it. I would like to know the code to do a "if file exist then" in visual basic. something like in a .bat file as follows. IF EXIST C:install.log ( @echo I'm here ) ELSE ( @echo Your File is missing. ) @rem @rem...

    TheFinder1,940 pointsBadges:
  • SQL Server 2008 query To Find Columns with incorrect information

    This is difficult to expalain so i will try and give you an example Record                  Surname               Age            Town 1                          Smith                   ...

    Davewaltonuk20 pointsBadges:
  • Crystal Report 10 error

    I am getting this error when I try to pull a crystal report: Property "New Generator" cannot be declared "overrides" because it does not override a property in a base class. When I comment out the errors the report pulls and when I make a change or edit the report or go out of the project and...

    Jjc47795 pointsBadges:
  • Syntax error = Pend what does it mean

    Transferring files mainframe to mainframe via NDM and suddenly getting:  Submitted DSN=> No DSN available: DSN Offset=0.                   

    Kmo5 pointsBadges:
  • XML file create from as/400

    Dear Friends, i have some data in PF and i want to that data in XML format how can i do that please tell about step by step becasue i am new in XML thanks

    Nelson01250 pointsBadges:
  • How can I write a SQL query to get the database name ?

    How can I write a SQL query to get the DB name ? Usually we use SELECT DB_NAME() AS DataBaseName, but at that time teh DB is in use. If we didn;t write use [dbname][/dbname], is there any way to get the DB name ?

    KulkarniMandar5 pointsBadges:
  • JDBC Connection from JAVA to iSeries DB

    I have a simple class that resides on my local drive. I am attempting to connect to iSeries I5V4 environment and do "select" from one of the DB files. When I run my .class file in Rational Application Development I ghet a "class not found" exception. How do I set classpath in RAD? Should my...

    Lenny2113115 pointsBadges:
  • I’M UNABLE TO COMPILE RPGLE SOURCE

    Hi All, In my application there is program in ILE source, code like bellow, I/COPY CMQGMOG                               ** note, sample uses defaults where it can  *                                           * misc fields...

    VENKYAS40075 pointsBadges:
  • Trimming Values with SQL Server Express 2005

    I have a column whose values range from 10-15 characters and whose last 7 characters I would like to get rid of. Can someone please show me how to do this? I thought it would be RTRIM but that didn't work for me. I can't use LEFT or RIGHT before the column because the column length is variable. I...

    Eabouzeid175 pointsBadges:
  • Renames clause in cobol

    while using renames clause we are defining dataname-1 thru dataname-n. if i am having same datanames in another group which output can i expect?

    Renames5 pointsBadges:
  • Visual Foxpro 9 Software use on Network

    HOW I CAN USE THE VISUAL FOXPRO 9 ON NETWORK, OR HOW I SET THE PATH OR DEFAULT SETTING TO USE ONE SOFTWARE CONTINNUE ON BOTH COMPUTER, I DON'T KNOW HOW TO USE OR WHAT TO DO ON THE CLIENT MACHINE TO RUN THAT PROGRAM OR SOFTWARE. I HAVE SOFTWARE WHICH I DEVELOP ON VISUAL FOXPRO AND RUN VERY WELL BUT...

    Vikaskrishivp5 pointsBadges:
  • how to declare date variable in cl programme?

    Pls tell me how can i declare date variable in my cl programme?

    6r1,520 pointsBadges:
  • how can insert values in array throw Scanner class or wrapper class?

    how can insert values in array throw Scanner class or wrapper class?

    Scjp5 pointsBadges:
  • Suggestions for VB.NET 2005 projects

    helloo....i needed some ideas frm u all for a project that me nd ma members have to do within 2-4mnths...we came up wid ideas such a lan chat program,college mgt systems....do any1 else have any otha ideas or suggestion???we will be working on VB.Net....

    Rinsa150 pointsBadges:
  • How can we use SQL 2000 or latest with Visual FoxPro

    Hello Friends I want use SQL in visual foxprox. how can do it. I ready many website, but all answer not fully cleared. Please send me Solutions. My Computer (SQL Server 2005 and Coputer Name) name is SEMSVR. Waiting your reply.

    Abhiindia15 pointsBadges:
  • VBA Excel – paste not working

    I have the following piece of code attached to my Excel worksheet:         ActiveSheet.Shapes("Object 407").Select         Selection.Copy         Range("BP106").Select         ActiveSheet.Paste The code is activated by making a choice in a drop down in the worksheet. ...

    Paustin5 pointsBadges:
  • How would we know which index is been used during Native IO reads or SQL query execution happens on that file during program is being run?

    For example on an as/400 Data base file, some 10 indexes are created? How would we know which index is been used during Native IO reads or SQL query execution happens on that file during program is being run?

    TNKR130 pointsBadges:
  • Find the SQL value behind the decimal

    I need to know if the numbers after a decimal point are greater than 0. What is the easiest SQL syntax to do this?

    Tslake9925 pointsBadges:
  • How can I ensure that the invoice data goes to the correct record on the subform datasheet?

    I use a form to hold the details of a client. The form has a subform [datasheet] which details each visit that the client makes. To do an invoice for the visit I have a pop-up form. I would like information from that pop-up form to be transferred to the datasheet subform. How can I ensure that the...

    Jhegarty5 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