• t-sql and AS400

    I want to develop a TSQL query. First I need to determine if all the numbers in one of the fields are in numerical order and also find the missing holes in the number sequence. Secondly I need to sort by another field and by a particular criteria.  The words that I need to sort-by would be...

    CompEng1,185 pointsBadges:
  • Does sFTP works for SNDDST command

    Currently our business is modifying all existing interface (From IBM V5R4M0) with Windows server to replace FTP by sftp. Our Question is -- whether SNDDST works even after we covert from FTP to sFTP, if there exists any issue what would be the alternate IBM command which works along with sFTP

    edava50 pointsBadges:
  • Monitor for job status DSPA

    I have to reset user sessions frequently on our iSereis. The job status is usually DSPA. How can I monitor for DSPA job status in QINTER on an iSeries and automatically end the sessions?

    Spepa15 pointsBadges:
  • AS400 vs SAP

    If you are familiar with AS400/BPICs/BAMCS can you catch onto SAP easily?

    Zero55 pointsBadges:
  • SFLRCDNBR-in subfile

    what should be the value of hidden field define under keyword SFLRCDNBR when subfile is empty???

    Nikrajpapa225 pointsBadges:
  • Drawer selection for Lexmark T652DN

    We are running V5R4 in our iSeries & we have AFP installed.  We want to automatically print to our new Lexmark T652DN from drawer 3 (plain A4), leaving drawers 1 & 2 free for pre-printed forms. The Printer has an IPDS card installed.  How do we go about achieving this?

    ITDavid140 pointsBadges:
  • Using CL Commands

    Hi, How run the cl commands using rpg/400? how to use the chkobj command in rpg program? (That mean without using command line from wrkmbrpdm?

    Gv197920 pointsBadges:
  • What is the best why to get started in DBA

    I have some experiance in SQL and Access and all the other MS software too. I deal alot with spreadsheets, and database in my job. I work alot with the AS400 and do alot of queries throught MS Access. What is the fasted and tghe most inexpensive way to get to the piont of being self sufficient as...

    CompEng1,185 pointsBadges:
  • Open IT Forum: Goals to round out 2011

    We're approaching the final quarter of 2011: What are some of your IT department's goals to finish out the year? What are some of the things you are implementing to position yourself for 2012? Whether it's updating your system documentation or updating your IT staff's certifications, we want to...

    MelanieYarbrough6,345 pointsBadges:
  • VSAM versus DB2 in CPU consumption

    Is it possible estimate how much more CPU is consumed by DB2 commands in relation to VSAM KSDS when access a row, through an index scan, in a organized DB2 table against a record reading from an organized VSAM KSDS file through the primary index? How much is it in percentage? Thank you very much in...

    Abelmart30 pointsBadges:
  • CGIConvMode BINARY – Help, I cannot make it working.

    In the CGI, I use iconv() to translate all input/output from ebcdic to utf-8 (ccsid 1208) and vice versa for the body. For the CGI output Header I don't process any translation, add x'15 twice to make a blank line. (as the HTTP default should make the translation from 37 to 819 for the http header)...

    PascalP20 pointsBadges:
  • Announcing the HP Elite Series Scavenger Hunt (sponsored)

    Today is the first day of the HP Elite Series Scavenger Hunt, designed to better educate potential customers about all of the great qualities that make HP Elite Series "elite." For details on how to enter check out the HP Elite Series Scavenger Hunt homepage. The Loot Grand Prize: 5 HP EliteBook...

    ITKE54,665 pointsBadges:
  • PC to AS/400

    Here are some points TOM and thank you. I will be using Client Access. My AS/400 on one side and PC beside it. I want my PC to work as console. I have my internet modem or HUB also here. What is the quick way to connect it. Do I need IP addresses also.  

    khan23275 pointsBadges:
  • RPG window subfile

    Can I dynamically alter the number of lines displayed in a window?

    Olddanitk5 pointsBadges:
  • Trouble printing from remote outq

    I setup a remote outq to a HP3500 printer. But it will not print any report I sent. It only prints the user and host name on the upper left corner of the paper

    Cheewing5 pointsBadges:
  • Disable BROWSE button from data transfer from iSeries server?

    Hi recently i discovered that my data transfer from iseries server aplication does not apply the object authority that i have in place so, all of my users can browse and download objects that they arent supposed to. My question would be if theres any way to disable the browse button on the...

    queque5 pointsBadges:
  • Programs using a PF

    how can we see that what are all the programs that uses a single PF? is that possible to see it?

    Rajasekhar151,395 pointsBadges:
  • Number of copies how to print in printer file

    i want to print 10 no of identical copies to print,how to we do to print in cobol/400

    madhuchowdary350 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:
  • ODBC problem Changing Structure Table

    I have a client program conncected via odbc to AS400, I defined a structure table (DDS) in the AS400 that the client program use, then I had to change the length of numeric field (3 to 8) but the client program not recognized. What I have to do?

    pmalopez5 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