Sssss, you don’t need to be an “Expert” at all to build a query for that.

Thanks for the answers. I decided not to go that route.

So Gowriking gave you a solution.
I provided a useful comment.
You can try this in SQL/400 and see how it works.
Show us what you’ve done and discuss with us what it lacks
and we’ll guide you to greater knowledge and a solved problem.

Phil

“adding an image to pdf“, if this is the Q, u didn’t mention here which ver of adobe pdf u have…. Whatever, full version Pro is required, if just u want to insert a image into a pdf file ! Though I am not sure cause basically, adobe pdf is an end product and therefore not meant to be editable. u need to dnld some kind of authoring program, insert the image and then remake as pdf file.

Try this….
Click tools > accout settings > adress books, if it shows the listed add books then close and mark contact folder for use with ur address book. If not listed, then click New and select additional address books, now next. It shows a message for an exit here u press OK and finish and close completely OL and restart again.

I got the solution to get the web attachments from (what looks at )bottom of the document into the respective rich text fields. For example: suppose we have two rich text fields , each rich text field is used to attach some files , and the application runs in web as well as notes. In notes there is no problem, but in web the attachment is done through the file upload control button and in doing that all attachment show the bottom of the document.And we do not know which attachement file corresponds to which rich text field.
1)First of all create two hidden text fields corresponds to each of the rich text field.
first field for tracking current file name to be attached and 2nd one to keep track of all the attachment file names for that rich text field.
2) Apart from field upload control button, create another button named “upload”. File upload control button is used to browse the file and the 2nd button i.e. “upload” is used to get all the selected file into hidden field, so that it contains the information of what are the files for the richtext field.
3) In the post save event of the form it is reqd to run the agent which actually gets all the name from the hidden field for respective attachment and get the attachment file save into harddisk and and attach into corresponding rich text field.

Charlie we r not Oracle expert thats why asking? I’m not teling to do my homework? I’m just asking my query? bcoz that is necessarry in my work?

The IP address it had is 192.168.2.1 but not working.

An address like 192.168.0.0 is a “private” (non-routable) address. Such addresses will not connect between different networks. Unless you are on the same network, you can’t connect to it.

You will need to use the “public” address if you are trying to connect across the internet.

I have now asked for a free as400 user profile on rzkh.com.

The rzkh.com name should resolve to a public address. If it does, you can use the name as the address. If not, they will tell you what name you should use or will send you an address to use.

Tom

here i modify my problem i have an excel with more than 300 column and same i have a PF
now how to transfer data from excel to PF in one time?

The IP address it had is 192.168.2.1 but not working. I have now asked for a free as400 user profile on rzkh.com. Hope it will help me.

Thank you to all for your valuable help !!

Thanks for your answer. Former OS (before reinstalling windows) is Win7 and works fine. I have turned IPv6 use off in network properties but didn’t work, and the meanwhile I have allowed new access and permission setting but NAS is still unable to be accessed.

Is it possible…

Yes. However, without knowing what product you are using to create the .PDF files, it’s not possible for us to know if you have a method available to you. You would need to read your product documentation to see if the feature is described.

Tom

…i have a only 256 fields in excel so how to do this…

I’m not clear on what you are trying to say. You said there that you only have 256 fields in Excel.

So why are you asking about transferring to a file with 300 fields? The Excel data doesn’t seem to be appropriate if it only has 256 columns. Where is the Excel data coming from?

Tom

I have downloaded it from the mochasoft website.

There should not be any useful address in the configuration if you downloaded it from the Mochasoft web site. Any address that shows up automatically with the product should be ignored and removed.

But if you downloaded it from a site that is made available by your organization, then an address could be correct. However, it might not be useful to you.

An organization could have pre-configured versions available. The address might work only within the local network of the organization. (That is, it could be a private (non-routable) address.

What address shows up? Where are you connecting from?

Tom

Again, be aware that CHAIN will only find one record that matches the two keys. In order to check other records that also match the same two key values, you can issue READ or READE statements in a loop. The CHAIN will position to the first record that matches; the reads will retrieve records that follow the first.

Your program would test each record to ensure that you process only the ones you want.

Tom

How do I make the second online program display records?

If we can’t see the relevant code for both programs, and the relevant definitions of the files, we can’t guess where something might be going wrong.

Show us what is running, please.

Tom

Before anything else, never forget that “SNDDST does not send ‘e-mail’. It sends distributions.”

‘E-mail’ is commonly expected to refer to SMTP. SNDDST does not do SMTP — the SMTP server does SMTP.

Beyond SNDDST, in order for a distribution to become an ‘e-mail’, it must be transferred over to the SMTP server. Usually, this is done through a particular configuration setup and through a combination SNA/DS and the Mail Server Framework.

SNA/DS is usually handled through the QSNADS subsystem. If QSNADS iisn’t active, use STRSBS to start it. The Mail Server Framework is started with the STRMSF command.

…getting “Send distribution completed successfully”message…

That implies that you have an appropriate recipient specified and that at least basic SNA/DS configuration was done. The SNDDST command was able to recognize your request and to place it into perhaps the appropriate distribution queue. You can use the WRKDSTQ to see status info about distribution queues. The DSPDSTSRV command can give viewing access to basic distribution services and some configuration elements. The DSPDSTLOG command can help track progress of distributions through the SNA part of the process.

Tom

I would suggest posting the query you are using, and some example data.

Dear friend, accidentally deleted, damaged by viruses, crashed of system errors MS Access files you can retrieve owing to
http://www.access.fixtoolbox.com
It makes all process in your some simply steps due to clear, intuitive recovery wizard.

or perhaps the OR’s should be AND’s ?