DSXchange

The tool will decrypt encrypted parameters; the decryption algorithm is not available to the likes of us (though can be determined if you are keen enough). Backups are your insurance against corruption. Within the secure UniVerse table, passwords would be stored in clear. You seem to have the techn...

You could store them in a UniVerse table to which only one user, who is not able to login, has any privileges. Then you can create a server routine to select from that table, and use the AUTHORIZATION statement within the routine so that, whenever it runs, it impersonates that particular user. For ...

Note, however, that encrypted parameters will be encrypted within the values files, and probably not suitable for your purpose. Ray, Another question...in a DataStage job, we usually give the Password as encrypted. When this is passed into the "Password" field inside a DB2 or an OCI stage...

No. However, if the Data Connection has an associated Parameter Set, and if the Parameter Set has values files, then you can access the parameter values from a values file. Note, however, that encrypted parameters will be encrypted within the values files, and probably not suitable for your purpose...

Gurus, I want to find out if a connection object (which has SID, User id and password) defined within DataStage can be called within a Unix shell script. Scenario: I am trying to convert an Informatica mapping into DataStage. This mapping calls a shell script which in-turn calls a bunch of SQL state...

ray.wurlod wrote:DataStage converts all line terminators to field marks. In that way it does not matter whether you are running on UNIX or Windows operating system.

Thanks Ray and Craig!

as Ray noted in your first reply, your issue was the inclusion of the @FM 'Field Mark' by the Execute Command stage. This needed to be stripped in order to be passed successfully which a search for your 'is not appropriate' error message would have turned up. Interesting...I was not aware that Data...

Ragunath, Did you try and pass this return value of the Execute Command activity directly into the downstream job as a parameter (which is declared within the job as an integer)? Is it output-ing an error? Another way I can think of would be to pass the return value into the downstream job (as a str...

Hello Gurus, Update on this issue: I am planning to use the approach suggested by Ray, that is to read the entire row as one field in Seq file stage and then substring the fields that are required! So, there is a workaround. However, I have one last question. Question : While "loading the colum...

But you'll note that that is now a completely different error. Now your metadata have to be corrected to match the data. It's running into problems at the CTRCT_STATE field, but the actual problem may be in the immediately prior field. Ray, it is exactly the same error in both the cases. In the com...

I think you specify newline as \n. Verify using on-line help or the manual. Ray, I tried it with \n and there is also an option namely "UNIX Newline character" in the Record Delimiter field of the CFF stage. Both are producing the same error: ##W IIS-DSEE-TFIG-00192 16:25:15(000) <Complex...

Question: There is another weird thing that happened. The CFF stage interface changed from normal (new) view to the older version view all of a sudden and "View Data" option is disabled!!! I tried restarting the window and stuff in vain. The other projects' CFF stage is showing the normal...

UltraEdit: Edit -> HEX Functions -> Hex Editor Thanks a bunch Craig. Now, I see that the record delimiter is Hex - "0A". I checked up the ASCII table and this is turning out to be "LF" (Line Feed). Question: There is another weird thing that happened. The CFF stage interface cha...

It does matter, and would in server jobs as well. You can not read a file defined to be fixed width if the records are not all the same size. A single VarChar column is NOT fixed width - I usually set both the field delimiter and quote character to 000 in these cases. Thanks for the reply. I have t...

I will try the '00A' approach, but as I told you, the tool is throwing an exception and saying it is expecting nothing more than one character in that option :) Don't bother, won't work. Created a small test file and not having much luck getting it to handle the 'short read' you need to do. So far....