DSXchange

Sure, it was actually a simple error, so its a little embarrasing. The code in question is: command = "echo File " : Ext : " missing | mailx -s Missing dirkm@reach.co.za" Call DSExecute("UNIX", command, output, systemreturncode) if systemreturncode 0 then Call DSLogInfo(systemreturncode, "Return cod...

Ok. It seems to be converting the EBCDIC to ASCII but there are the following problems: - Do you use the sequential file !?! The mainframe EBCDIC file is binary. - When do you know when the next row starts? I created the job like this: [[[MAINFRAME_FILE(ebcdic)]]] ----> [TRANSFORMER] -----> [[OUTPUT...

Dirk, Want to share your detective work (sanitized as appropriate ) with the others on the list? It may help someone else in the future! Regards, Ray -----Original Message----- From: Dirk Moolman [mailto:dirkm@reach.co.za] Sent: Thursday, 11 October 2001 20:38 To: datastage-users@oliver.com Subject:...

In this case (Unix), I think I only received one byte of the code like you indicated below. I had a look at 127 in Unix, and it has no relation to the error I should be getting. I managed to track down the error by just splitting and testing different parts of the command. It is good to know about t...

For issues between DataStage clients and servers, the most comprehensive list is to be found in the InterCall manual (Intercall is the underlying architecture for UniObjects, the interface used for this connection). This manual can be found at: m Within the file JOBCONTROL.H, which exists in a subdi...

The fourth argument of DSExecute returns the exit status of the executed command. That is, if you are running a UNIX command it is a UNIX error, if you are running an NT command it is an NT error, and if you are running a UniVerse command it is a UniVerse error. You need to consult the appropriate r...

There are two complementary functions. ASCII(x) will convert from EBCDIC to ASCII. EBCDIC(x) will convert from ASCII to EBCDIC. HOWEVER----- Beware that there is more than one variant of EBCDIC. (This is particularly true in Japan.) -----Original Message----- From: Brundyn, Pieter [mailto:pbrundyn@m...

Is there a function in datastage that will convert EBCDIC to ASCII !? thanks pieter NOTICE: This message contains privileged and confidential information intended only for the person or entity to which it is addressed. Any review, retransmission, dissemination, copy or other use of, or taking of any...

Where do I find the error codes and their meaning ? I am looking through the manuals - couldnt find it in the online help. The server job developers guide doesnt have all the error codes. Im getting a return code 127 when running DSExecute in one of my jobs. Any help appreciated. Thanks Dirk Moolman...

Hi Peter, sorry but I thought you were talking about DS username and password. I think that the following way is a solution to read job parameters from a secure file: 1. Put parameters in a file 2. Open this file and read parameters from a job control: OpenSeq.............. ......... Loop While Read...

You could try: "123456789" + 0 -----Original Message----- From: Brundyn, Pieter [mailto:pbrundyn@metropolitan.co.za] Sent: Thursday, 11 October 2001 5:30 PM To: datastage-users@oliver.com Subject: convert strings to numeric values Is there a function in datastage to convert a string to a valid numbe...

Is there a function in datastage to convert a string to a valid number. eg. "123456789" -> 123456789 I know of num but that function only returns true(1) or false(0) if the string is not a number. Regards Pieter Brundyn Customer Oriented Applications Division (Comparex Africa COA) For: Comparex Afri...

Sorry, I should have been more specific. Im having a problem with my job parameters ( ie. Database login, DB password ) rather than the DS Server params. Im taking the defaults on the DS Server params as the user running the shell script will be assumed to have access to the DS Server. Is there a wa...

MetaStage 2.2 is not NLS enabled yet. So thats the expected behavior. The upcoming MetaStage 2.3 will have NLS capability. Its expected to be released near the end of the year. At 01:27 PM 10/10/2001 +0400, you wrote: >Hi, All! > >When I import Business objects universe that contains Russian names o...

The directory containing the perl executable and the pabx.bat file are not accessible via the PATH environment variable. -----Original Message----- From: Simon Vollett [mailto:svollett@comdyn.com.au] Sent: Wednesday, 10 October 2001 17:40 To: datastage Subject: Executing a command from the dos shell...