Emailing from iSeries with multiple attachments
I am looking for a way to send an email from the iSeries with multiple attachements. The attachments are documents (.doc, .pdf, etc.) in the IFS not spool files. SNDDST only allows one attachment and most of the other options I have seen involve spool files. Does anyone know how this can be...
I am looking for a way to send an email from the iSeries with multiple attachements. The attachments are documents (.doc, .pdf, etc.) in the IFS not spool files. SNDDST only allows one attachment and most of the other options I have seen involve spool files. Does anyone know how this can be...
0 pts.
FTP from iSeries to PC
I have installed a Cerberus FTP Server on the PC and I need to FTP a flat file FROM the iSeries TO the PC. However, when I enter the PUT statement it returns with : 227 Entering Passive Mode (213,210,55,130,4,22) 425 Unable to open the data connection ...
I have installed a Cerberus FTP Server on the PC and I need to FTP a flat file FROM the iSeries TO the PC. However, when I enter the PUT statement it returns with : 227 Entering Passive Mode (213,210,55,130,4,22) 425 Unable to open the data connection ...
Reg Data extraction from one environment to another
Hi Consider i have testing library and development library in my library list. Say for eg, given a shipment ID i need to copy all the relevant data from testing enviroment to development environment. Since the file objects reside in testing and dev environment how will i be able to fetch data...
Hi Consider i have testing library and development library in my library list. Say for eg, given a shipment ID i need to copy all the relevant data from testing enviroment to development environment. Since the file objects reside in testing and dev environment how will i be able to fetch data...
FTP from iSeries DB2 to iSeries AIX (Oracle)
I'm taking a FILE and using CPYTOIMPF to either create the flat file pipe delimited to another DB2 File or directly to the IFS as *PCASCII. Using iSeriesNavigator, I have no problem looking at the IFS. No issue with iSeriesNavigator and looking at FILE either. Using FTP, <namefmt 1>,...
I'm taking a FILE and using CPYTOIMPF to either create the flat file pipe delimited to another DB2 File or directly to the IFS as *PCASCII. Using iSeriesNavigator, I have no problem looking at the IFS. No issue with iSeriesNavigator and looking at FILE either. Using FTP, <namefmt 1>,...
AS400 intreface with other platforms
Can anybody tell me how to interface As/400 with other platforms say windows or linux for example
Can anybody tell me how to interface As/400 with other platforms say windows or linux for example
ADDSVRAUTE & DDM files
I am writing an Order Entry application that requires use of file on a remote system, which I will access via DDM. The problem is that we have hundreds of order entry clerks and turn around is great. I do not want to open a can of worms by having to create and maintain remote system user id's ...
I am writing an Order Entry application that requires use of file on a remote system, which I will access via DDM. The problem is that we have hundreds of order entry clerks and turn around is great. I do not want to open a can of worms by having to create and maintain remote system user id's ...
vb.net and AS400
I have to develop a VB.net application where I download some data from an IBM system I(AS400) to interface with some Microsoft products. The data from the system i(AS400) will be a list of vendors and various data elements that will help me determine if they are the cheapest vendor. I will need...
I have to develop a VB.net application where I download some data from an IBM system I(AS400) to interface with some Microsoft products. The data from the system i(AS400) will be a list of vendors and various data elements that will help me determine if they are the cheapest vendor. I will need...
Front End Development for AS400
Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some initial research on that and...
Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some initial research on that and...
Is it possible to reorganize a very big transaction in one night?
I want to reorganize a very big transaction file in day end process and it cannot finish within 1 night. The problem is RGZPFM command lock that file ,so the day after , user cannot use that file because it is locked. Do you have any ideas to help me?
I want to reorganize a very big transaction file in day end process and it cannot finish within 1 night. The problem is RGZPFM command lock that file ,so the day after , user cannot use that file because it is locked. Do you have any ideas to help me?
Renaming a file in the IFS directory
I am receiving a file daily in an IFS directory, I manually copy the file to a library using the CPYFRMSTMF command. I want to automate the process so that it will be done every day at a specific time. The challenge is that the file name in the IFS directory is different every day, for example it...
I am receiving a file daily in an IFS directory, I manually copy the file to a library using the CPYFRMSTMF command. I want to automate the process so that it will be done every day at a specific time. The challenge is that the file name in the IFS directory is different every day, for example it...
SQL Logical Functions
Which is better to use and why? Also, which function is faster and why? Coalesce -or- IfNull
Which is better to use and why? Also, which function is faster and why? Coalesce -or- IfNull
Deriving tape header info for use in logging and messaging
I would like an example, preferably in i5/OS CL, for a method to retreive the volume number of the tape just used for a complete system backup so that I can put out a message to the system operator queue or the system log which includes the tape volume number. I tried this with CHKTAP which puts it...
I would like an example, preferably in i5/OS CL, for a method to retreive the volume number of the tape just used for a complete system backup so that I can put out a message to the system operator queue or the system log which includes the tape volume number. I tried this with CHKTAP which puts it...
Journal Receiver Sequencing
Hi All, We have a test and production data library, we have a separate journal for each that fill journal receivers in their respective libraries. In TEST our system managed receivers always start at sequence 1 when a new receiver is attached, in production the sequence number continues from the...
Hi All, We have a test and production data library, we have a separate journal for each that fill journal receivers in their respective libraries. In TEST our system managed receivers always start at sequence 1 when a new receiver is attached, in production the sequence number continues from the...
Using RPG constants in Static Embedded SQL
I have tried to use an RPG IV constant (D-Spec with a "C" usage and value) in embedded, static SQL as a host variable and the compiler fails. I was told this was possible, but so far I do not know how to do this. Not surprisingly, IBM documentation is practically worthless in trying to find out...
I have tried to use an RPG IV constant (D-Spec with a "C" usage and value) in embedded, static SQL as a host variable and the compiler fails. I was told this was possible, but so far I do not know how to do this. Not surprisingly, IBM documentation is practically worthless in trying to find out...
Tape Expiration
Does anyone know how to automatically check a tape to make sure that it has not expired before running a backup. I know you can use BRMS but we do not have BRMS on our system. We have set up the backups to put an expiration date on them but if the operators put the wrong tape in I get a call at...
Does anyone know how to automatically check a tape to make sure that it has not expired before running a backup. I know you can use BRMS but we do not have BRMS on our system. We have set up the backups to put an expiration date on them but if the operators put the wrong tape in I get a call at...
Blocking certain fields from being downloaded using Client Access
Hi, By using WRKQRY, we can select the files and create output files. My problem is how do I block certain users from downloading certain sensitive fields like Price in the output file. Thanks..
Hi, By using WRKQRY, we can select the files and create output files. My problem is how do I block certain users from downloading certain sensitive fields like Price in the output file. Thanks..
Use SNDDST command to send email
I'm using the SNDDST command on the AS400 to send email but its failing to deliver to users outside of my company. The emails are delivered to inhouse users but not outside email addresses. Can anyone inform why this is occuring and how to fix it?
I'm using the SNDDST command on the AS400 to send email but its failing to deliver to users outside of my company. The emails are delivered to inhouse users but not outside email addresses. Can anyone inform why this is occuring and how to fix it?
RLU Document
Hi I have been working with program described printer files till now. But I would have to start working on externally described printer files. I know we can use RLU to design externally described printer files but I do not know how to use RLU. Can anyone please point me to any document on how to...
Hi I have been working with program described printer files till now. But I would have to start working on externally described printer files. I know we can use RLU to design externally described printer files but I do not know how to use RLU. Can anyone please point me to any document on how to...
Using an array in embedded SQL in RPGLE
Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = :odPart(01) C+ and TkQty01 = :odQty(01) C+ and TkPart02 = :odPart(02) C+ and TkQty02 = :odQty(02) There's more to it than that but that should...
Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = :odPart(01) C+ and TkQty01 = :odQty(01) C+ and TkPart02 = :odPart(02) C+ and TkQty02 = :odQty(02) There's more to it than that but that should...
Conversion Project
We are currently working on a project which will at a later date will require alof of data conversion on our existing system to fit the new file structures which are currently been developed. The project is been developed using COBOL on an iSeries, the old and new files will all be physical files....
We are currently working on a project which will at a later date will require alof of data conversion on our existing system to fit the new file structures which are currently been developed. The project is been developed using COBOL on an iSeries, the old and new files will all be physical files....
