DSXchange

I still doubt, whether SELECT DISTINCT FROM TABLE will give out records without any syntax error. oops :oops: That would work better with some column specifiers, like a * or smth (and by "better", I mean, "as opposed to not at all"). Thanks. I've tweaked the original example.

(edited: as per kumar_s, put the * in "select distinct" examples, below.) You said "key column", as in just one key. Cool - that makes it easier. You said when you "select distinct" you're getting all 257573 as distinct.... Hmm. Can you post that SQL query? Ok... Color ...

addited: looks remember-me is working now, beats the heck out of me why it wasn't in the testing I describe below. As per not working earlier, probably my fault for connecting to "dsxchange.com" instead of "www.dsxchange.com" 'Remember me' should just be a cookie AFAIK - do you h...

The session timeout (e.g. for needing to log in again) seems pretty short; though I suppose is this a way of reducing load on the php server? How much would it hurt to double the timeout delay? With IE (6.0) and Firefox (1.5 & 2.0): r.e. logging in, "remember me" isn't working for me, ...

from the oline help r.e. FTP Plug-in "Telnet Before Command. The telnet command to execute on the remote machine before starting a job. Telnet After Command. Specifies the telnet command to execute on the remote machine after completing a job." Sounds like your before-command will run a sc...

Linux RedHat 3, eh? By "failed over" do you mean... converted? ported? migrated? Is any of the hardware the same? Or did you plug in a new 8-way box to your network, leaving the old 4-way one hooked up as well? As for your final question, "Is it a config file issue or some OS level se...

Why am I paying more taxes than the others? :( :cry: :x Well, this is just a toy example. I didn't want to put all the tax-fields in there, or we'd be looking at something like this to support your client list, yes? :wink: TAX_1:TAX_2: ... :TAX_999:TAX_1000 I'm just ungruntled 'cuz I'm untangling m...

Can you give me more information: Why does splitting this file make your life better? What is the problem if you just leave it alone? (I am sincere about asking this - the reason you want to split the file influences the way you need to split it.) Run these commands on your file and paste the output...

Hi All, Is there any way to pass the column name instead of the vlaues comming in I dont need the values i just need the column name to pass. Ex: seq file -> tx -> seqfile i want to pass 1st columnname from seqfile to transformer instead of value. note: It would help you get better answers if we kn...

create a loop to calculate data for one month and then using that data to calulate data for previous month and so forth , thus create a loop such that if in Dec - it should calculate data for 11 times. eg - using May data to get april data, using that derived april data to get jan march data and th...

Our coding is on AIX server, but the code will be later ported to Windows. So, We want to make sure that we do not use anything Unix specific, that may not work on Windows. If you have to deploy on windows, your server's DataStage install is going to include the MKS toolkit (the parallel stuff requ...

ray.wurlod wrote:Users are created using unskilled labour!

A man and a woman need to be involved at some point. And performance is slow. Using parallelism, however, nine women ought to be able to create a baby in one month.

Arrggghhhh - that was reaallly bad.

= #job_parameter# You have to define the job parameter in your job first. The #job_parameter# is easy enough to understand for the filter stage. I'm more curious about an easy way to do something like this on the JobProperties.Paramters tab: Parameter Name: job_parameter Prompt: The job parameter T...

Once again, I agree with Ray. I would add this... As you learn the ways of scripting, put some energy into learning how the host operating system thinks. It will help you to know about pipes, signals, memory handling, disk management, and so on. With respect to a long term DS career, learning some C...

Please explain your logic a little more.
"when the source record value is negative, then
it represents the age > 80."

Perhaps an example would help me.
Do you mean like this?