RE: [sqr-users] Call System Using: #status = 0 with HP-UX... but -1with Linux !

["franck.masson" <franck.masson2002@laposte.net>]

Hi Peter,
 
What should be the encoding definition for this File ?
what happen if in this file there are Null character ?
 
Franck,



> Message du 25/04/08 17:42
> De : "Peter Burton" 
> A : "This list is for discussion about the SQR database reporting language  
>from Hyperion Solutions." 
> Copie à : 
> Objet : RE: [sqr-users] Call System Using: #status = 0 with HP-UX... but -1 
>with Linux !
>
> 
> Lalit,
> 
> Like I said you can do just that using SQR 8.3.1 (though 9.3.1 is better).
> 
> You can open an external file, read in the contents, and then insert the 
>contents into the database.
> 
> Peter
> 
> -----Original Message-----
> From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org 
>[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of 
>Lalit Chaudhry
> Sent: Friday, April 25, 2008 11:16 AM
> To: This list is for discussion about the SQR database reporting language 
>from Hyperion Solutions.
> Subject: RE: [sqr-users] Call System Using: #status = 0 with HP-UX... but -1 
>with Linux !
> 
> Hi Peter,
> 
> ThankYou, but print-image would transfer the image from the database to print 
>file, what I was trying to do is the other way around, reading the windows 
>based image file and load it into the sql database
> 
> Lalit
> 
> Peter Burton wrote:
> Lalit,
> 
> Hyperion SQR v8.3.1 and higher has been able to just that.
> 
> However I would go with Hyperion SQR 9.3.1 since there is additional 
>functionality with regard to the PRINT-IMAGE command and the various formats.
> 
> Peter
> 
> -----Original Message-----
> From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org 
>[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of 
>Lalit Chaudhry
> Sent: Friday, April 25, 2008 10:50 AM
> To: This list is for discussion about the SQR database reporting language 
>from Hyperion Solutions.
> Subject: Re: [sqr-users] Call System Using: #status = 0 with HP-UX... but -1 
>with Linux !
> 
> Hi Group,
> 
> Has anybody able to load employee pictures to the database in an automated 
>manner, rather than going manually one at a time, for example, reading a file 
>and uploading to the oracle database
> 
> ThankYou
> 
> Lalit Chaudhry
> 
> christophe.kirch@orange-ftgroup.com wrote:
> Hi Group,
> 
> We have several sqr's that calls unix command.
> 
> We are currently under HP-UX, but are switching to Red Hat Enterprise
> Linux
> - with HP-UX: no issue: everything works fine, and #status = 0
> - with Linux: the unix command also runs perfectly, but the #status always
> say -1 !
> 
> => any idea why Linux does not return us 0 when the command runs with
> success ?
> Did we miss a setting on Linux side or SQR side or even Peoplesoft side ?
> 
> [We are on Psoft HRMS 8.9 / Ptools 8.47]
> 
> Thank you
> Rgds
> Chris
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> 
> 
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> 
> 
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> 

 Créez votre adresse électronique prénom.nom@laposte.net 
 1 Go d'espace de stockage, anti-spam et anti-virus intégrés.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users