DSXchange

You could probably call an Unix Program in an External Source stage, if you can mount it and read it in Unix line as ArndW says. EBCDIC to ASCII may create problem , but there sure will be some workarounds. See an article on the dd command and verify if its applicable on your flavor of Unix . Conver...

I guess it will work , provided the column bfile operates on contains a valid DIRECTORY object as seen by oracle and file name.

These are my default compiler & linker options: APT_COMPILEOPT=-O -fPIC -Wno-deprecated -c APT_COMPILER=g++ APT_LINKER=g++ APT_LINKOPT=-shared I created a static library archive file with 2 *.o object files compiled using g++ [ -fPIC option not used because it is a static *.a file ] I defined 2 ...

Can you successfully view data on the source for your reference link ?
Did you specify that column as Timestamp ? Then you may have to enter microseconds in teh format property for that column.

The State file is a binary data file that stores an uint32 or uint64 value depending on your operating system. in a 64 bit platform , it stores an uint64 value in each 8 byte block of data per node. To read current values of a surrogate key state file , you can use the unix command od -xc <state Fil...

Since you are using a Teradata Connector in 8.7 , Can you try setting the partitioning method to hash and sort by the keys with 'unique' option selected. I see that the Teradata connector doesn't allow you to specify a sequential execution method like the older stages.

@chulett - not meaning to hijack , but how will you read a hashed file as an UV table ?

Me thinks the 'encoding style' was changed in the WSDL definition or the Web service operation defn , may not have been a datastage change.

Im curious - if you are using an ODBC stage , and network latency is low enough , you may be able to use the oDBC stage as a reference link input , with its reference returns multi rows property set in the transformer ( identity stage) . The file will be stream input link .

Should be a directory accessible from the Oracle server as a local directory . I guess it can be NFS mapped also. Otherwise FTP the *.jpg files from your datastage server path to the Oracle server Image directory path [ you may have to use Binary transfer mode for FTP] , and run the procedure in the...

You can create a stored procedure to do this load . Use the BFILENAME(<DirObjectName>,<PicFileName.jpg>) 1. create a directory object in oracle CREATE DIRECTORY "DIRNAME" AS '/a/b/c/images'; Use the stored proc to 2. Insert BFILE INSERT INTO YOUR_BLOB_TABLE VALUES ( v1,v2,BFILENAME('DIRNAM...

Although not recommended by anyone[myself included ] , you can possibly create a Q pointer in your projects VOC file to the job's log file and then import it as an UniVerse file definition to read its records - using a hashed file stage.

Try using LongVarChar datatype, and set teh data element property as XML

Do you need an SSL Keystore file ? Security tab has a place for that . By the way did you get an XML response in the job log ? Going by your prior posts , it seems like your request envelope was not received at the web service endpoint.

Just navigate to the Security and Proxy tab of the Stage page in a web service transformer ,and see if any of the settings ( tons of them) are applicable to your IT internet infrastructure. To enter proxy server name , navigate to the Proxy Tab , you will find a place to type it in.