DSXchange

[quote="tcjInteresting. Wouldn't having two instances of the same DS version on the same machine be a violation of the license? (no I do not work for IBM ) I thought that the hardware would of been the limit of the number of jobs concurrently started/running. Interesting that it is DS that has the i...

Aileen, the message is very clear - you have declared a column separator in your source file stage to separate the columns. DataStage expects a line in the source to have 5 of these separator characters to split the data into 6 columns. Your source data has 71 of these. You will need to check your s...

Thanks a lot .please tell me How i can include an extra stream in your DataStage job that updates the hashed file when required? Sudheepkv, adding an update or write stream to a DataStage hashed file is part of the basic job design method. You drop the hashed file stage on the designer canvas, pull...

In order for changes to the uvconfig file to take effect, you need to run uvregend and restart the DataStage server - have you done that? One possible cause of the error message is trying to open a hashed file that is not there; so your deleting the hashed files in that directory could be a cause. I...

Michael, are you sure you won't relent and use a DS/Basic function to do this? It would only be 9 lines long... StringLen = LEN(Arg1) Ans = '' Skip = 0 FOR i = 1 to StringLen CurrentChar = Arg1[i,1] IF CurrentChar = '[' THEN Skip = 1 ELSE IF CurrentChar=']' THEN Skip = 0 ELSE IF NOT(Skip...

Sunshine, I think the frustration from myself and others on this forum is when a question is asked whose answer can be found by going to the product documentation and reading the appropriate section. So apart from the suggestion of getting qualified training on the product I can only recommend to ac...

For debugging purposes, let's stick with output to a sequential file. How do you convert the CHAR(18) to an integer in your job? I think integer values are limited to +/- 2,147,483,647 after which they are stored in floating point format. Your uvconfig will contain a setting for WIDEZERO and EXACTNU...

Sunshine, did you try the DataStage telnet after you did this to see if it works? If it still doesn't work, please talk to your system admin who might know a bit more about the installation and the last step is to talk with a support professional at IBM/Ascential or whoever your support provider is.

Luciana, I think that ds_developer's point is that strings with a "-" and "." (or a ',' if the NLS locale is enabled) will be returned as legal numeric, so you don't need to use an additional function to remove them.

can you open a cmd window and use Windows FTP to connect to that machine? This might not be a DataStage problem but a connectivity issue.

JD,

I can't take the credit for that - you were the one who tried it in the first place But there really is no other easy method.

sunshine - questions like this don't belong here! There's a really cool utility out there - it's called the Internet. I took 30 seconds and called up "MKS tookit" to get the MKS website, then opened up their product documentation and got the telnetd documentation page. This explained that the MKS da...

JD - OK, I assume that means that it had been validated in one project and not in another. Using the DSX file is the only method that I would consider using to compare files.

The database errors are often written to the log file, so they would be visible using method (a). With method (b) you could get the last error information from the DSGetLinkInfo() function in DS/Basic.

Identical jobs should create identical .dsx files from the same version of DataStage. What didn't work when you tried this?