• AS400 %trim

    Hi I have a question,i wanted to right trim the field to remove the spaces. but when iam doing it ,iam unable to do it. i did like this eval fld1 = %trimr(fld1). so please suggest whether this is correct or not?      #TBLDGH      ...

    iiiiiiiiiiiii335 pointsBadges:
  • How do you use multiple member files in Crystal Reports?

    i have to retreive data from as400 iseires files that have multiple members and most do not have a logical for that member without creating a new logical is there anyway to tell crystal reports to use a certain member ?

    tcuccaro40 pointsBadges:
  • AS400 comparing large database files, cobol code taking too long

    Hi, I need to compare 2 large database files on the AS400, they have 20 million + records each. They are both keyed uniquely, exact same file layout. I need to identify inserted, updated and deleted records. I tried using cobol program reading first file with the unique logical, and matching with...

    ARTZONE25 pointsBadges:
  • AS/400 transactions

    If iam in the mid of transaction of some sqlcodes if suddenly server is shut downed due to power down or sumthing what will happen. (Transaction will be committed or Transaction will be rollbacked or status ‘COMMIT PENDING’, or transaction wil stop)

    NicyChn110 pointsBadges:
  • Track Database SSL connections

    Hello, We have VeriSign certificates installed to allow for SSL connectivity to Telnet, the Database...etc. Problem is that I need to be able to track who's using SSL to connect to the database on port 9471 and output it to a file. Any ideas on how to go about finding this information. I cannot...

    Bggas400160 pointsBadges:
  • As 400 database linking to the website

    Hi I want to link the account enquiry option on the AS 400 to the company website so that users can make account enquiries on the site. my question is how can I link the two?

    Dumieprince5 pointsBadges:
  • Data Structure in CL

    Hi,     Upto my knowledge we cant use data structure in cl... Is it Possible? If it Possible then How?

    22917515 pointsBadges:
  • How to classify AS/400

    I am in the process of writing a plan to integrate some software  into our AS-400 system. When referring to this system, is there a category I can classify it as? For example…”The purpose of this proposal is to help defer the costs of integrating our new software with our...

    TrentTheTrainer5 pointsBadges:
  • Restoring journal receivers

    A search400 reader wrote in with this question: A situation has come up in our shop where we need to restore the QAUDJRN receivers from the production box to the test box (due to storage limitations and the large size and number of the receivers to be restored). We ran the following command: RSTOBJ...

    Leah Rosin575 pointsBadges:
  • DBF in AS/400 – last record written

    Hi , There is  file which has 6 fields and the first four as its key. Is there any way to figure out which is the last record written into it.   Thanks

    Atti123135 pointsBadges:
  • AS/400 Authorization Lists

    I created a AUTL with only Read access to certain files.  When my user ran an SQL statement against one of the files in the AUTL that he is a member of it said that he did not have authority to the file.  Why would this not work?

    TomLiotta125,585 pointsBadges:
  • AS/400 tab text delimited format of physical file

    Hi , Using i series utility you can download PF as Text Tab Delimited format in your PC.However when I do the same by CLP using CPYTOIMPF using FLDDLM as X'05' or *tab , I get a text tab delimited file which is not completely same as the file downloaded using I series utility.

    Atti123135 pointsBadges:
  • Want to delete objects of type ‘File’ except ‘source physical file’

    I have taken output of DSPOBJD in a database file. Now I want to delete all the objects having type '*FILE' and object attribute 'PF' but the problem is I don't want to delete 'Source physical files'. I just want to delete files except 'Source physical file'. can anybody suggest how to do that ?

    pankaj2r100 pointsBadges:
  • query/400

    plz tell me how to work with query/400 on as/400 machine...thanks

    ten20081,150 pointsBadges:
  • Transfer Data from AS400 to Excel using Reflection

    I need help learning how to create a file transfer from the AS400 to an Excel spreadsheet using Reflection. I am not a "techie"; what I've learned has come from countless hours of using the "help" button and reading technical blogs. I knew how to create DTF requests when our company was using...

    Jillofalltrades50 pointsBadges:
  • Export AS/400 database to new website

    how would we go about exporting our as400 product database of 2,000 items (without images - only image name or link) to our new website?  we would likely be using a Joomla content management system (CMS) website but would use standard HTML if we had to.

    Sjames007725 pointsBadges:
  • DB2 Process automatically Shutdown

    At  our site using IBM DB2 database there some problem with our DB2 Database services stop automatically .Error log  shown the  DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Thanks, Nilesh

    Linuxroot35 pointsBadges:
  • Reading a file in Reverse Order in CL Program

    ) In CL program how can we read a data base file in reverse order.

    Chraghuveer25 pointsBadges:
  • Declaring the same file twice with two OPENID and reading the same file twice in CL Program

     Is it posssible read a db file while declaring twice with openID     and reading the same file twice

    Chraghuveer25 pointsBadges:
  • sflcode & COBOL/400 code

    i have a database file name emp         file name=Emp R emprec    Eno           10p    Ename      10a    Esal          10p k Eno and subfile name is empsfl  sflrec Contain fields   SEno        10p   SEname   10a   SEsal       10p sflctl contain indicators...

    madhuchowdary350 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