DSXchange

Has anyone used the FTP Enterprise Stage with DataStage Enterprise Edition running under USS?

We're getting a message:

Could not locate operator definition, wrapper or UNIX command "pftp"

Any ideas?

Rob

Rob, can you tell me whether you were able to design a sparse look up under this configuration. Did anyone else manage to do a sparse lookup against a DB2 V8 on mainframe? Mathias, We haven't tried to do a sparse lookup from DataStage on Linux or AIX using the ODBC EE Stage. Our main execution plat...

I wish I did have suggestions. I think the compiler is licensed by number of concurrent users, and processes will wait for a free slot when that number is reached; so perhaps part of the long compile times might result from this bottleneck. But this is conjecture on my part and might be completely ...

RobJ, have you noticed a difference between jobs with and without transform stages? Oftentimes a job (even a very complex one) with no transform will compile quickly whilst a simple job with a transform might take a long time. If this is the case, it might have to do with the c++ compiler. Yes, it ...

We're running DataStage EE under USS on the mainframe and my developers are complaining about the length of time it takes to compile parallel jobs. The mainframe is quite heavily loaded, but the time required does seem excessive (up to half an hour for jobs with 20 or so stages in them). We have inc...

track_star wrote:The DB2 EE operator will not connect to mainframe DB2. You have to use the ODBC EE operator or the DB2 API stage.

Thanks track_star. Are there any benefits to using the ODBC EE Stage rather than the DB2 UDB/API Stage?

I'm trying to configure DataStage 7.5.1A Enterprise on a Linux (SLES 9) server. I think I'm pretty much there, but I want to clarify whether it's supposed to be possible to read data from mainframe DB2 using the DB2 UDB Enterprise Stage, or whether I'm limited to the DB2 UDB/API Stage when accessing...

ray.wurlod wrote:Sometimes the line termination character is converted to a field mark (@FM, or Char(254)) as part of being captured.

Yup, that's it. Convert(@FM,"",Execute_Command1.$CommandOutput) gives mewhat I need. Thanks.

Typically a command output has leading and trailing line terminator characters that you need to strip off. Try using Trim() or Convert() function to remove all Char(10) characters. Thanks Ray. Your suggestion was certainly on the right lines. Not sure what the character in question is (not Char(10)...

I'm having problems with passing a string parameter from a job sequence into a parallel job. The value I want to pass is obtained from a file in the AIX file system, so I'm trying to use an Execute Command activity, whose output is the required parameter value. So far so good, the Execute Command Ac...

Yes, it's OK to set NLSMODE to 0 and test. But remember the 4013th corollary to Murphy's Law - you won't have a problem if you have a backup. That was good advice. I'm not sure if it was related, but some indexes got corrupted around the same time I set NLSMODE to 0. Some (but not all) jobs seemed ...

[quote="ray.wurlod"]Yes, it's OK to set NLSMODE to 0 and test. But remember the 4013th corollary to Murphy's Law - you won't have a problem if you have a backup.[/quote] I was thinking that even as I wrote my last post. Thanks for the advice. I'll give it a go next time I get the server to...

[quote="ray.wurlod"]It won't corrupt any jobs. The same can't be guaranteed for the job designs, however. In these you have specified NLS mapping, and now the NLS maps won't be loaded, so no mapping can take place. You will receive lots of warnings to this effect. Further, the results with...

I have the opposite problem. We installed NLS, but now find it's incompatible with our DataStage Enterprise USS component. Has anyone tried setting NLSMODE back to 0 and doing a uvregen? Is it likely to corrupt jobs which have been written with NLS enabled?

[quote="alraaayeq"]All, I am going to install gcc latest version ( I think 3.4.2/3) in order to test how could we use it for PX jobs. does any one has Good/Bad experience , and only practical experience ( I got dozens of theories about using free/ proprietary c++ compilers) that could help...