You probably need to trim the string, and append a X’00′ to the end. This command expects a null terminated parameter

Can the two system connected via TCP/IP? If so, the easies way to move spooled files is to create a remote outq from AS/400 to AS/400. The link below has instructions for creating remote outq’s. Using this method the spooled files can be easily moved from one system to another and they can be easily directed to the appropriate outq on the target system. the concept is that a remote outq delivers the spooled file to the named outq on the target system. So the process of moving a spooled file from system a to system b is to create the remote outq on system a pointing to the appropriate outq on system b, then simply moving the spool files from their current location to the remote outq. Quick, easy and extremely reliable.

Have a look at exit point programming. A quick look at WRKREGINF pointed me to exit points QIBM_QZDA_SQL1 and QIBM_QZDA_SQL2.

Your statement is missing the equivalent of this part of my example statement:

select * from filea
full outer join fileb on keya = keyb
full outer join filec on keya = keyc or keyb = keyc

Thanks Tom

this issue usualy comes from Auto matic Updates you should turn off the Automatic update may the problem will be solve.

Do you know of any website link where i can obtain information that OSV5R3 can not save the actual spool file but only spool file information and in effect can not restore any spool file.

The IBM Information Center website says it.

But a website isn’t needed. The RSTOBJ command says it on your system. Show him the <help> text. In part, it says:

• For job queues, output queues, user-defined message queues, logical files, and data queues, only the object descriptions are restored; the contents of those objects are not restored.

No need to go to a website when the restore command says it.

However, this applies to the system save and restore commands. At V5R3 and earlier, the content of spooled files can be extracted into user spaces. The user spaces can be saved and restored. And spooled file content can be written from restored user spaces. It’s not perfect since the connections between the original job information and the spooled file are lost, as other attributes might be. But you can write programming or purchase a product that does it.

Tom

Dear Uma,

Select DIRECT DEBITING..

Bill of Exchange : The payment terms for Bill of exchange is 30/60/90/120…… days.

Bill of Exchange payment request : Cannot be used here.,

use T-code FBZP and configure in Payment Methods in Country, Payment method in company code. Also check your Bank details available in House Banks and Bank determination.

Check also in the Customer Master and update it.

While making the invoice, do not forget to give your payment method.

Regards,

You can use WRKJOBSCDE and press F6=Add, or you can run the ADDJOBSCDE command:

ADDJOBSCDE JOB( MYJOB )
           CMD( CALL LIB1/PROG1 )
           FRQ( *WEEKLY )
           SCDDATE( *NONE )
           SCDDAY( *MON *TUE *WED *THU *FRI )
           SCDTIME( 1100 )
           USER( XATMN )

The job will run at 11:00 AM every week on Monday through Friday.

Other parameters can be added as needed.

Tom

Do you know of any website link where i can obtain information that OSV5R3 can not save the actual spool file but only spool file information and in effect can not restore any spool file. I need to show this to my boss to convince him that our model 820 w/ OSV5R3MO is limited by OS version and can not save SPOOL file. My boss is mainframe guy and is not convinced that our current iSeries can not save actual spool file. We also don’t have the BRMS installed in our machine. Thanks.

Asp.net web services can use only HTTP chanenel.
Not supports msmq and tcp binding…

WCF is flexible because its services can be hosted in
different types of applications. The following lists
several common scenarios for hosting WCF services:
IIS
WAS
Self-hosting
Managed Windows Service

WCF = Web services + .Net Remoting + MSMQ + (COM+

http://www.cisco.com/en/US/products/hw/routers/ps133/products_tech_note09186a008020b19e.shtml

Dear Hari
It is not clear what you wanted to say. Can you explain?Is it that that I need to create a url to get the attachement. But I want to clarify that there are mote than one attachment fields and the attachement files need to be attached at respective attachment field in lotus notes as well as web environment.

I have a request form in which there are 4 richtext fields for attachment. The application is used in lotus notes as well as web. When files are attached into these richtext fields in notes there is absolutely no problem. when files are attached using file upload control in web then attachments are placed at the bottom of the document when viewed in Notes environment.
And this is not recognized that which file is attached into which attachement field. How can I resolve this issue, i.e. I want the attachment to be placed into corresponding rich text fields in notes as well as web. Can you help me?

Older ver of MS excel has limit with 65536 rows per worksheet. Probably excel 2007 may help u !(though not sure) or some vba coding also helps. One more criteria is how did u copy / import rows from where i.e. access table / other databases…. See more info MS ref and excel 2007
If u have pre-excel 2007 wb open in excel 2007 in compatibility mode then, the wb has 65,536 rows, not 1,048,576. (just guessing, but not sure, cause u mentioned “table”).

This is my third try at posting this. It’s the FROM clause a little cleaner and with correlatives added to help in the discussion:

From  kodavmxp/FMTADY01 t1
FULL OUTER JOIN  kodavmxp/FMTAFR01 t2
  On t1.DYCDTP = t2.FRCDTP And t1.DYNCPR = t2.FRNCPR
FULL OUTER JOIN  kodavmxp/FMTABR01 t3
  On t1.DYCDTP = t3.BRCDTP And t1.DYNCPR = t3.BRNCPR

There are two FULL OUTER JOINs.

The first tells how t1 and t2 match and also what values to use for t1 when a row exists in t2 but not in t1 and vice versa. But it doesn’t help determine what value to use from t3 when there is no row in t1. It doesn’t say how t2 and t3 match nor what to do when they don’t match.

The second tells how t1 and t3 match and also what values to use for t1 when a row exists in t3 but not in t1 and vice versa. But it doesn’t help determine what value to use from t2 when there is no row in t1. It also doesn’t say how t2 and t3 match nor what to do when they don’t match.

The FROM clause results in ambiguous results.

You need to define all possible combinations. What exactly do you want to happen for each of them?

Tom

how to configure acl?

…I didn’t think it related to executing QSH in batch and with a variable.

It’s definitely related when extra quotes are added that shouldn’t be there.

But the idea of using a literal or a variable is sound. Just don’t put quotes in the variable that aren’t present in the literal.

Tom

Surely a simple count…

I don’t think I’d use a “simple count”. I’d look to see how the database could return a value telling how many were subscribed. As subscriptions were created or deleted, the value would automatically increment or decrement.

By using some separate object such as a data area, it’d be necessary to have something that would be guaranteed always to increment/decrement correctly. It might also be necessary to restrict some other process from modifying the object. How could you stop someone from running CHGDTAARA and simply setting the value?

If we knew something about the DBMS and the general design of the tables/views, it might be easy to build the restriction into the database itself.

Tom

Please find my query below and help me, since i have been struggling for 2 days to write this query.

Select COALESCE(DYCDTP,FRCDTP,BRCDTP) Dtp,
COALESCE(DYNCPR,FRNCPR,BRNCPR) Prd,
COALESCE(DYNDFK,’0′) Df,
COALESCE(DYNDPT,’0′) Dp,
COALESCE(FRNFFK,’0′) Ff,
COALESCE(FRNFPT,’0′) Fp,
COALESCE(BRNBFK,’0′) Bf,
COALESCE(BRNBPT,’0′) Bp
From kodavmxp/FMTADY01
FULL OUTER JOIN kodavmxp/FMTAFR01
On DYCDTP = FRCDTP And DYNCPR = FRNCPR
FULL OUTER JOIN kodavmxp/FMTABR01
On DYCDTP = BRCDTP And DYNCPR = BRNCPR