--bothunbr-- The best solution I've seen for this situation is to generate the Email Template in an external XML file as an HTML ... passing in the Variables needed to make it personable. I believe I could look through my examples and find some for you to see if interested ... just send us an email ...

--bothunbr-- The writeExecl task is a very memory intensive task. It does (and will) take some tweaking on your Java Memory to get something that large to work since it has to load the file into memory to get it to process. Creating a CSV would be a cleaner (and quicker) alternative and still give y...

The easiest way to do this is to create a Template with your headers already defined. Something like: Double_Header_XLS_Template.JPG Then, set up your project for the writeExcel Task like this: WriteExcelTask_BasicTab.JPG Add the Data Element: WriteExcelTask_DataElement.JPG And execute ... your fina...

The <if...> is setup as a control task but, at this time, the "else" element hasn't been activated. It is a reserve word to keep it available for a future release when activated.

Currently, you will have to create a "true" <if> statement and a "false" <if> statement to code for this.

Search the Forum for "/QSYS.LIB" -- you will find a few examples of how to setup the path to insert/retrieve data to/from an IBMi Library/Table using (s)FTP(s). You also have the option to insert the data into the IBMi using a Database connection and SQL Insert. There are examples of that on the For...

Satyatiwari, By default, GoAnywhere's JDBC connections to the DB2 Engine will automatically throw an error if truncation occurs during an insert. There are a few things you can do to eliminate Truncation of data being inserted into smaller field sizes. 1. You can clean your data prior to insert, mak...

Axel, You can perform this functionality easily using the SQL Task to retrieve a unique list of Supplier codes, then loop through that Rowset and calling the SQL Task again (inside the loop) to retrieve the items into a separate Rowset then writing that 2nd Rowset to a CSV. In Pseudo Terms: <sql Tas...

Mark, There are several ways to do this ... try something like this: <project name="Date Test" mainModule="Main" version="2.0"> <module name="Main"> <createWorkspace version="1.0" /> <timestamp version="1.0"> <format outputVariable="DateStamp" pattern="yyyyMMdd.HHmmss" /> </timestamp> <!-- Need to c...

LP, Try something like this: <project name="TestThis" mainModule="Main" version="2.0"> <module name="Main"> <setVariable label="Init Error Var" name="MyError" value="YepItWorked" version="2.0" /> <sftp resourceId="Ricks Laptop sFTP" version="1.0" onError="setVariable:MyError=NopeItDidntWork"> <put s...

LP, Use the following syntax: <setVariable label="Set sqlError" name="sqlError" value="0" version="1.0" /> <sql label="Connect to Server" resourceId="${ JobServer }" version="1.0" onError="setVariable:sqlError=1"> You can set the values to whatever you want. I normally use 0 for "it worked" and numb...