DSXchange

These were taken from command line, logged in as the DS user I am running the jobs with. Is that ok or do I need to put it into a job? I see the PROD data)kbytes is slightly lower which may just be under the requirement. Would this be one? It looks like a lot. DEV time(seconds) unlimited file(blocks...

Hi, My 3 input columns are: name; start_ip; end_ip and in a transformer I have a routine that works out all the valid ip addresses for each of these ranges. The routine loops through all the possible IPs concatenating them into a string with the 'NAME', a pipe delimiter and Char(10), all into a long...

As JG says use the Iconv in a routine * Convert the date to internal vInternalDate = Iconv(InputDate,"DYMD[4,2,2]") * Check the status of Iconv vStatus = Status() *Check the length of the input = 8. Problems with dates like 200701 If Len(InputDate) = 8 Then vStatus = vStatus Else vStatus =...

Determine which client machine had the connection from the IP address and restart it. That should clear the TCP connections.

try this netstat -a | grep dsrpc do you find sessions with status of FIN_WAIT_2? If there are these are sessions that did not complete the closing handshake correctly. You need to disconnect these before you can restart the server. Do get rid of these connections I believe you can do $DSHOME/bin/uv ...

Out of curiosity what is the source you have with 600 columns?

have you checked the files are the same using unix is your partitioning the same for the 2 inputs to the stage?

add another column with the derivation of @INROWNUM. This may help you see what is happening.

Is this a Server job or EE job? You have said it is server but posted in the EE forum.

value in colA is the last character of colB didn't know that! ...then i would also expect 'Same' to work...... ...are you running this job on the same number of nodes as the job that created the dataset? ..can you do as Ray suggested and take a look at the score? perhaps you could post it here...

have you tried running the job? it may just be a limit for viewing within datastage.

In the docs folder of your client install, have a look at the basic.pdf, this can be very useful, particularly in the Quick Reference/Sequential File I/O. This will give you some better ideas about what is available, then you could search the site for the BASIC functions you think you need to use an...

While it is true (in version 7.5 and earlier) to state that there is no benefit to running server jobs in a site where Enterprise Edition is installed and server jobs are licensed

That's all I said Ray, I never mentioned a downside. I didn't mean to be really misleading.

I couldn't list all the differences between so many versions without looking at release notes, but out of curiosity why would you need to know? I could understand if you are thinking of upgrading but why so many versions?

Server Edition does not use strong typing so will often not complain about chars in number fields, so you need to perform the checks yourself. Num(input.field) should work for this example, allowing only records through that have numeric values in field. You can then set another link as a reject lin...

Do you realize that your server edition jobs will continue to run on as server edition jobs and have no benefit from running on an installation that includeds Enterprise Edition? The jobs need to be completely re-written as Enterprise Edition jobs, most likely with very different approach to solving...