MC Press Online Forums http://www.mcpressonline.com/forum/ MC Press Online Forums en Sat, 31 Jul 2010 07:15:24 GMT vBulletin 1 http://www.mcpressonline.com/forum/images/misc/rss.png MC Press Online Forums http://www.mcpressonline.com/forum/ QuickLook: iDocs from inFORM Decisions http://www.mcpressonline.com/forum/showthread.php?17968-QuickLook-iDocs-from-inFORM-Decisions&goto=newpost Fri, 30 Jul 2010 18:44:37 GMT Good question. In the beginning a customer would order a specific component to accomplish a specific task - laser printing a form, for example. Then... Good question. In the beginning a customer would order a specific component to accomplish a specific task - laser printing a form, for example. Then solutions came for faxing or emailing a document. There were vendors that specialized in document storage and retrieval as well. What evolved were rules and conditions for customers to "stitch" all this together, and literally take what used to be a laser printed form, and route it and/or store it integrating all these technologies, and based on conditions and rules that users can define. It started simple in the beginning, such as a laser printed form that could also be faxed. But the new intelligent routing capabilities (like inFORM's SmartRouting) can make decisions about how to process and distribute each page of a spool file, on the fly... and this is where companies really save time and money.

Certainly, all the small steps along the way save time and money, but the total "paperless", intelligent routing takes it to a whole new level. ]]> Document Management Danforster http://www.mcpressonline.com/forum/showthread.php?17968-QuickLook-iDocs-from-inFORM-Decisions Using GMAIL server for email with SVAIREMAIL http://www.mcpressonline.com/forum/showthread.php?17967-Using-GMAIL-server-for-email-with-SVAIREMAIL&goto=newpost Thu, 29 Jul 2010 05:11:23 GMT Tom,

I am trying to run Javamail_Hello world program and am getting "javax.mail.MessagingException: Could not connect to
TransportSend Error " error.

My inputs are as follows:
//main pgm
msg = AirEmail_newMessage('myusername':'mypwd');


//service pgm

D svDefaultHost C CONST('gmail.com')

'
'
svHost = svDefaultHost;
'
'
// Host: URL Location of the SMTP server
svPropKey = new_String('mail.host');
svPropValue = new_String(%trim(svHost));
Properties_setProperty(svProp: svPropKey: svPropValue);


// LocalHost: Required or HELO will fail
svPropKey = new_String('mail.smtp.host');
svPropValue = new_String('smtp.gmail.com');
Properties_setProperty(svProp: svPropKey: svPropValue);

The reason I am using gmail server is that I am unaware of my companies mail servers url&host name.
I have pinged gmail.com from my IBM i and it succeeds(I can access gmail from my company network). I added couple of properties by referring
http://www.mkyong.com/java/javamail-...-smtp-example/ to our service program but it still fails.

Could you please tell what I am doing wrong? and what is the difference between mail.smtp.host and mail.host
properties exactly??

Sorry to bother you,

-David ]]> Advanced, Integrated RPG DavidVilla http://www.mcpressonline.com/forum/showthread.php?17967-Using-GMAIL-server-for-email-with-SVAIREMAIL Am I doing anything wrong in RDP in the Member Filter http://www.mcpressonline.com/forum/showthread.php?17966-Am-I-doing-anything-wrong-in-RDP-in-the-Member-Filter&goto=newpost Wed, 28 Jul 2010 15:30:34 GMT Using RDP (V7.6.0.1) while I am creating Member Filter from the Source File under a Library I found the RSE is creating duplicate Member Filters for... Using RDP (V7.6.0.1) while I am creating Member Filter from the Source File under a Library I found the RSE is creating duplicate Member Filters for me.

For example expand a library (MYDEVLIB) then select a source physical file (QRPGLESRC) and right–click on it, go to New and Member Filter. In the Member Filter window type first few character of member name (for e.g. IFS – as in my source file contains multiple members starting with IFS) select the Member type (for e.g. RPGLE) of those members and then click Next button. Enter your Filter Name (for e.g. DIBS_RPGLE_MBR_FLTR) and click Finish button. I found it creates two Member Filters of the same name (DIBS_RPGLE_MBR_FLTR).

Is this a bug or something new of which I am not aware of!!!

Can anyone please try this and confirm.

Thanks
Dibs ]]> IBM DibsInForum http://www.mcpressonline.com/forum/showthread.php?17966-Am-I-doing-anything-wrong-in-RDP-in-the-Member-Filter How to connect to SQL Server 2005 using user authentication from RBD/RDP http://www.mcpressonline.com/forum/showthread.php?17965-How-to-connect-to-SQL-Server-2005-using-user-authentication-from-RBD-RDP&goto=newpost Tue, 27 Jul 2010 09:33:07 GMT Using RBD & RDP I am trying to connect (while creating a new connection) to MS SQL Server 2005 and for that I am using “SQL Server 2005 – Microsoft SQL Server 2005 JDBC Driver Default” (sqljdbc4.jar).

In the connection screen when I am using a valid User Name and Password (already created in SQL Server) I can successfully connect to the SQL Server,

But when I am trying to use the “Use integrated authentication” option (In the targeted SQL Server my user id already been created with user authentication type) getting the error “The driver is not configured for integrated authentication” with the below details – com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.

After looking in the web I found it need to use the sqljdbc_auth.dll for the integrated authentication before calling the connection object from java.

I have no idea how I can configure this in RBD/RDP, or is there any other way around to connect to the MS SQL Server using the integrated authentication option.

Any guidance/help will be highly appreciated.

Thanks & Regards
Dibs ]]> IBM DibsInForum http://www.mcpressonline.com/forum/showthread.php?17965-How-to-connect-to-SQL-Server-2005-using-user-authentication-from-RBD-RDP TechTip: Spooled Files and PDF, Part One http://www.mcpressonline.com/forum/showthread.php?16162-TechTip-Spooled-Files-and-PDF-Part-One&goto=newpost Mon, 26 Jul 2010 17:42:16 GMT For anyone whose has a spooled file containing overlapping lines for things such as underlining or bold text and is trying to make it work, I've been able to resolve the problem. Here's what I've done:

I was able to find this resolution using the following PDF Reference guide:
http://partners.adobe.com/public/dev...FReference.pdf

First, use the code supplied by bdietz400 on 1/23/2009: Thanks bdietz400.
In procedure WritePages add the following to the select clause after "// handle FCFC instruction"
when FCFC = '+';
WriteData('0 0 TD'+LF:7);
FCFCplus = '+';
I added the FCFCplus field to this so we can track if the FCFC field has had a "+" in it yet. I so, we need to start using line positioning commands.

Second, add some new variables and a procedure to the top of the program:
DLineAdvance PR
// Misc variables ----------------------------------------------------
DFCFCplus S 1A inz(' ')
DLineSpacing S 2P 0

Initialize the variable "LineSpacing" to be based on the VertSize field:
Add right before the /end-free in the SetupPage procedure. I found 1.7 to work best for my reports, but you may need to tweek this number.
LineSpacing = VertSpace/1.7;

In the WritePages procedure, add the following line just below the "// handle FCFC instruction" comment:
LineAdvance();

At the bottom of the program, add in the LineAdvance procedure we defined and referenced earlier:
//++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++
// Line Advance
//++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++
PLineAdvance B
DLineAdvance PI

/free

select;
when FCFCplus = '+' and FCFC <> '+'
and LineSpacing < 10;
WriteData('0 -' + %char(LineSpacing) + ' TD'+LF:8);
when FCFCplus = '+' and FCFC <> '+'
and LineSpacing >= 10;
WriteData('0 -' + %char(LineSpacing) + ' TD'+LF:9);
endsl;

/end-free
PLineAdvance E

This was the easiest way I found to get the underline and bold working. Hope this is useful. This change probably won't make text bold but it will make your PDF look proper with the printing of underlines and line advancement. ]]> Document Management get_sporty http://www.mcpressonline.com/forum/showthread.php?16162-TechTip-Spooled-Files-and-PDF-Part-One Changing CPI to 6400 printer http://www.mcpressonline.com/forum/showthread.php?9869-Changing-CPI-to-6400-printer&goto=newpost Mon, 26 Jul 2010 16:13:22 GMT We converted from a IBM 6400 using Twinax to IBM 6400-010 (and also a 6400-050) using Lan connection. Our problem was when trying to print anything... We converted from a IBM 6400 using Twinax to IBM 6400-010 (and also a 6400-050) using Lan connection.
Our problem was when trying to print anything other than 10 CPI, it wound not stop condensing the print. (and *NLQ would not work)
So 15 CPI came out 17 CPI, 12 CPI came out 13 (ect..).
Our solution we came up with (after a week of usless research) was to make a custom emulation on the 6400 panel
to be Epson emulation (not Proprinter), and *Disable the "20 CPI Condensed" setting".
Also on the AS/400 printer configuration, make the "MFRTYPMDL" option say "*IBM6408EP" .
We can now print using any CPI and also print *NLQ . ]]> Document Management punchcard76 http://www.mcpressonline.com/forum/showthread.php?9869-Changing-CPI-to-6400-printer 80% discount on Easy400.net free software http://www.mcpressonline.com/forum/showthread.php?17964-80-discount-on-Easy400.net-free-software&goto=newpost Sat, 24 Jul 2010 21:26:02 GMT You would not believe it. If you download Easy400.net free software during week-ends you get 80% discount. Do not miss this great opportunity! ... You would not believe it.

If you download Easy400.net free software during week-ends you get 80% discount.
Do not miss this great opportunity!

Giovanni ]]> IBM jbvperotti http://www.mcpressonline.com/forum/showthread.php?17964-80-discount-on-Easy400.net-free-software SAAS web Based Email Marketing software http://www.mcpressonline.com/forum/showthread.php?17963-SAAS-web-Based-Email-Marketing-software&goto=newpost Fri, 23 Jul 2010 07:13:58 GMT Can anybody list out the Email Marketing Software SAAS providers ? Can anybody list out the Email Marketing Software SAAS providers ? ]]> Managed Services/SaaS robertflorish http://www.mcpressonline.com/forum/showthread.php?17963-SAAS-web-Based-Email-Marketing-software Debugging DB2 Stored Procedure using RDP http://www.mcpressonline.com/forum/showthread.php?17953-Debugging-DB2-Stored-Procedure-using-RDP&goto=newpost Thu, 22 Jul 2010 10:28:19 GMT After installing the fixed pack for RDP 7.6.0.1 now I can setup a breakpoint from the RDP debugger view while debugging a stored procedure. But... After installing the fixed pack for RDP 7.6.0.1 now I can setup a breakpoint from the RDP debugger view while debugging a stored procedure.

But getting the error “Server: CPF7E12 identifier does not exist” while trying to Monitor Expression (select the variable then right click and then select Monitor Expressin form the list) for a variable in the debugger. ]]> IBM DibsInForum http://www.mcpressonline.com/forum/showthread.php?17953-Debugging-DB2-Stored-Procedure-using-RDP Two Doubts in AIR // http://www.mcpressonline.com/forum/showthread.php?17962-Two-Doubts-in-AIR&goto=newpost Thu, 22 Jul 2010 09:14:20 GMT Thank you Tom. Your answers are as awesome as your Book!! :-) Thank you Tom. Your answers are as awesome as your Book!! :-) ]]> Advanced, Integrated RPG DavidVilla http://www.mcpressonline.com/forum/showthread.php?17962-Two-Doubts-in-AIR Answers to Questions from the Advanced, Integrated RPG Webcast http://www.mcpressonline.com/forum/showthread.php?17961-Answers-to-Questions-from-the-Advanced-Integrated-RPG-Webcast&goto=newpost Wed, 21 Jul 2010 21:10:53 GMT Had difficulty downloading...]]> Hello Everyone,

Thank you for joining in today. Here are a few answers from today's questions. More to follow.

Had difficulty downloading at poi.apache.org>
Here is a link to the older versions, I am using 3.0.2-FINAL in the code:
http://archive.apache.org/dist/poi/release/bin/

I noticed the book doesn't come with the source code, is there some way to get access to the souce code examples used in the book?
You can download the source in the "Reviews, Errata and Downloads" link for my book at the mc-store website, here is the link
http://www.mcpressonline.com/forums#...7821-Downloads

When generating an EXCEL from RPG, can you condition fonts, colors by column or rows?
I will have to look into formatting the entire column/row, but I am attaching the results changing the fonts and colors for a cell. xls is forbidden, so I attached a screenshot.

Attachment 49

This is not a complete list. I will provide more answers soon.

Thank You,
Tom
Attached Images
]]> Advanced, Integrated RPG T.Snyder http://www.mcpressonline.com/forum/showthread.php?17961-Answers-to-Questions-from-the-Advanced-Integrated-RPG-Webcast Very Simple SQL issue http://www.mcpressonline.com/forum/showthread.php?17690-Very-Simple-SQL-issue&goto=newpost Wed, 21 Jul 2010 16:00:56 GMT The IBM i 6.1 release includes support for table-less queries with the VALUES statement. You can just code up: VALUES 1+1 The IBM i 6.1 release includes support for table-less queries with the VALUES statement. You can just code up: VALUES 1+1 ]]> DB2 K.Milligan http://www.mcpressonline.com/forum/showthread.php?17690-Very-Simple-SQL-issue Printing AFPDS and overlays to PCL or Postscript type printer http://www.mcpressonline.com/forum/showthread.php?17952-Printing-AFPDS-and-overlays-to-PCL-or-Postscript-type-printer&goto=newpost Wed, 21 Jul 2010 13:53:47 GMT to restart a printer on a specific page, I have found you need to enter not only the 'RESTART' parm but also the 'PAGERANGE' parm

hope this helps ]]> General alnelson http://www.mcpressonline.com/forum/showthread.php?17952-Printing-AFPDS-and-overlays-to-PCL-or-Postscript-type-printer DB2 SQL error codes 551 http://www.mcpressonline.com/forum/showthread.php?17745-DB2-SQL-error-codes-551&goto=newpost Wed, 21 Jul 2010 11:51:25 GMT Hello Mong, That means user is not authorized on Objects whatever Object he is going to used in Program . In this case embedded SQL Error codes... Hello Mong,

That means user is not authorized on Objects whatever Object he is going to used in Program . In this case embedded SQL Error codes 551 would be there. ]]> SQL Daccitpvtltd http://www.mcpressonline.com/forum/showthread.php?17745-DB2-SQL-error-codes-551 Trigger Question http://www.mcpressonline.com/forum/showthread.php?17624-Trigger-Question&goto=newpost Wed, 21 Jul 2010 11:50:01 GMT Hi rpgflunkie, In this case while adding Trigger on Physical file by the help of Command ADDPFTRG.There is one Parameter Trigger update condition... Hi rpgflunkie,

In this case while adding Trigger on Physical file by the help of Command ADDPFTRG.There is one Parameter Trigger update condition (TRGUPDCND) default value *ALWAYS has been used that means The trigger program is called whenever a record is updated, whether or not a value changes. ]]> DB2 Daccitpvtltd http://www.mcpressonline.com/forum/showthread.php?17624-Trigger-Question