Search results for query: *

hi! evrytime i want to transfer a file to another machine, i just use CRTDDMF in my CL program. can i also use this for a SAVF that i want to transfer to another machine? operators in our company usually create a SAVF and then uses FTP to transfer the SAVF to the other machine. is there a...

thanks a lot guys!! i was able to use CPYTOIMPF in my CL program and it worked!

hi everyone! i hope somebody could help me with my dillema. Im using CPYTOPCD command in my CL program to copy files to a common PC folder which will be accessed by a VB program. I need this files to be comma delimited when i download them to the common PC folder. Any help will be...

HI! Thanks for all your input.I now have the conversion to and from hundred of years format. Will share it sometime, after i've finished coding my programs.Too many pgms, too little time (*sigh).

HI there! Just wanna ask, is there a formula to convert a hundred year format in as400 to gregorian and vice versa.

hi there! I dont know if this could help you, but if you just wanna try RPG programming on your PC, you could check out this site : WWW.TEXAS400.COM...you'll just need to register and they'll give you access on their AS400, and from there, you could write your codes and even compile them...it...

hi jack. had a similar problem like yours, only in our case, we interface a PC application with AS400 as backend. The PC application uploads text file to a PC folder in QDLS which is then processed by the AS400 RPG programs. The problem in this scenario is that sometimes, the uploading is...

No prob pantherv...that's what we're all here for, to help each other =)

hi! what is the exact error message you've encountered when you run the CL pgm? i think it would be advisable to use a variable in your CL pgm for the query selection instead of specifying the criteria directly in the OPNQRYF statement. This way, you'll be able to check (watch the variable in...

thanks jerry, glad to hear from you again. as of this moment, i was able to find a document with regards to socket programming, vb on the client side and ile-rpg on the server side. With the use of socket APIs, im hoping to connect my front end system to the backend. I'm still in the process...

Hi there! I'm trying to send and receive data to our AS400 through a VB pgm. I've checked our AS400, it's using Telnet to communicate through Client Access with 5250 emulator. I've seen codes that have used winsock control but i still dont have any idea on how this control could communicate...

thanks mike and pansophic! i just have one more question, what do u mean by "getting a good packet capture"..i'm sorry but i'm not into technical terms, so those terms are kinda new for me. pls enlighten me. thanks!

Thanks for the reply. I've checked our AS400, it's using Telnet to communicate through Client Access with 5250 emulator. I've seen codes that have used winsock control but i still dont have any idea on how this control could communicate (send and receive data) to AS400 just by defining the...

after compiling your rpg program with embedded sql, try checking the spooled file for the compilation. instead of seeing your sql statements, you could see there the API's used by your SQL statements togeteher with its corresponding parameters. I've tried using these routines in my pgm instead...

HI there! Just wanna ask if you have any idea how I could send a request from my VB application directly to AS400 application program just by using IP address? I've tried using ODBC through Client Access driver and it worked but directly accessing AS400 files is very risky. I've also tried...

you could try using SDA (Screen Design Aid) for your DSPF and if the field that you need in your screen is only for display, create an output field in your screen layout. hope this could help you.

thanks for your reply jerry. it was very helpful, i was able to access the AS400 file using ODBC, and instead of hardcoding the connection string parameters, i've just used the dsn name i've defined in the Client access driver.

hi loonybin! You've mentioned that you've used REFFLD in your screen.Maybe you could try checking the field of the file you've used in your REFFLD if it's really 18S,0

I'm trying to write a code in visual basic that allows the user to encode a product code and when the user clicks a button, the description of the product code must be displayed. The product description could be retrieved from an AS400 file. Is there a way for me to retrieve the description by...