PH & SQL

[Darren Reely]

I would look into the compatiblility of that version of PH with that
version of Oracle.  Perhaps 8.0.5 isn't certified for some reason.


A possible alternative to your problem may be to define the other database
in your dictionary like the following sample:

Database
MFG                                                                 &
  Type
ORACLE                                                                &
  Null values
allowed                                                        &
	;;Uses my default database on current machine
  Open
ORACLE@OPS$USER                                                       &
  Owner PBSYS
 
Database
PMFG                                                                 &
  Type
ORACLE                                                                &
  Null values
allowed                                                        &
	;;Uses database on production machine
  Open
ORACLE@username@mfg/password                                              &
;  Open
ORACLE@OPS$USER                                                       &
  Owner PBSYS


Then you can reference the tables by the PH database name you've defined
like:

	file po_test in mfg alias pt1
	file po_test in pmfg alias pt2
  .
  . 
  .
	let trans_id of pt2 = trans_id of pt1
	let descr of pt2 = descr of pt1
	let partno of pt2 = partno of pt1
	put pt2 ;;<<---update remote file



If you find the answer, please let us all know.

Darren.



"Madeleine D." wrote:
> 
> A question for PH-Imbedded SQL:
> 
> We have an HP-UX installation, using PH813d3 and Oracle 8.0.5.  I have put
> together a ghost screen to export records, based on given criteria, via
> imbedded SQL and an Oracle link to an Oracle table at another division.  I
> use PH Cursor and SQL OPEN statements to access the table, with temporaries
> to load the values.  The code looks basically like:
> 
>  SQL INSERT into PO_TEST   &
>   (TRANSACTION_ID,DESCRIPTION,PARTNO)  &
>   VALUES  &
>   (:T_RCPT_TRANSID, 101, :T_RCPT_PARTNO)
> 
> Everything works just fine, except:  I need to send a NULL on a numeric
> field if one of my PO Record fields has a given content, so I have:
> 
> IF PO_FIELD = "CONTENT"
> THEN LET T_NUMERIC = NULL
> 
> That seems to work just fine on a similar character field, but the numeric
> causes a load failure everytime.  Oracle spits back:
> 
> ------------------------------
> ORA-01488: invalid nibble or byte in the input data
> ------------------------------
> 
> Without the numeric field in the SQL statement, everything loads just fine.
> 
> So, any ideas as to what I might do?  I can't just not send the field,
> because depending on criteria, it will have content.  I know I could
> conditionalize the SQL INSERT, but it would be nice to know why this is
> happening.
> 
> thanks in advance.
> 
> Madeleine D.
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.