Hi there
I have two calls to a AS400, they both call the same program but using
different methods and returning different errors.
Both programs expect a string of 7 blank character i.e. ' '
First:
The Call
<cfquery datasource="#dsn#" name="qry1" result="qry.result2">
{CALL libraryName.programName(' ')}
</cfquery>
The Error
Error Executing Database Query.
[RPG9001] Error RPG0233 caused program programName to stop.
Second:
The Call
<cfstoredproc datasource="#dsn#" procedure="libraryName.programName">
<cfprocparam type="in" cfsqltype="CF_SQL_CHAR" value=" " />
</cfstoredproc>
The Error
Error Executing Database Query.
[SQL0204] programName in libraryName type *N not found.
As you can see I'm not a AS400 guy, at all! But I figured these two
calls did the same.
Can anyone see what I am missing. Or what the error messages mean?
Cheers
Andy J
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269128
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
