DSXchange

If you want to use the Internet Explorer browser for installing on Linux, you'll be running it on a remote Windows computer. You can of course choose to use a browser on the local Linux computer, but that would be a supported Firefox browser. Just follow the installation instructions as documented. ...

That filter option is where you would put a UNIX command to operate on your file (not going to be much use on a binary file). You could use a transformer constraint after the CFF stage. The constraint tab on the output tab might be an option if you convert the substring you want to do into a defined...

projectname will be case sensitive. Make sure you are matching case exactly and make sure that projectname does not contain any non-display characters. See what this gives you: dsjob -lprojects 2>/dev/null | grep projectname Then: dsjob -ljobs $(dsjob -lprojects 2>/dev/null | grep projectname) Mike

Look in appendix B of the parallel job developer's guide for all of the transform functions available. String functions would have options for you: DCount, Index, Field, [].

It would be good to become familiar with what is available.

Mike

Forgot to add when i log in to DS Admin, i cant seepermissions tab enabled for the project which was manually assigned to me in DS admin This tells me that the ID that you logged in with does not have the DataStage and QualityStage Administrator role (only a DataStage administrator has access to th...

What did your official support provider have to say?

It sounds to me like it's either a limitation of the reject link for the Oracle Connector or a bug.

Mike

Yes. It's not all that different from a single table SELECT. However, you will have to provide the SELECT statement rather than having the stage generate the SQL. Provide the SELECT statement with a job parameter or combination of job parameters.

Mike

RCP is a parallel feature, so I doubt you'll ever get it to work with a server shared container. I'd stick with the parallel dataset. Someone was asking a while back about using ramdisk for the scratchdisk resource. I don't see why that might not be a viable option for the resource disk that paralle...

The LastRowInGroup() transform function eliminates the need for an aggregator after the transformer. This transform function requires an upstream sort stage (even if it is set to no sort).

Mike

You have a misunderstanding. DataStage permissions as set via the DataStage Administrator client are separate from the roles and permissions established via the Information Server admin console. You still have to grant your LDAP users and/or groups permission for a DataStage project via DataStage Ad...

Everything on PaulVL's list is important.

I would also add space monitoring.

Never let your $TMPDIR location fill up.

Developers never think about deleting old and unnecessary datasets until there is a crisis. I like to routinely delete any dataset that is more than x (e.g. 30) days old.

Mike

It depends...

Start with some initial research:

1) What kind of API does your LDAP vendor provide?
2) Do you need a real-time interface, batch interface, or something in between?

Mike

Is this a new installation? On the surface, it seems like the security setup for your installation has not been configured completely. If this is an installation that has worked previously, but is no longer working, then that would lead the troubleshooting down a slightly different path. Your inform...

I gave up on the Multi Client Manager long ago. I always found it way too unreliable if client patches were ever needed.

I prefer different client versions to be in separate VMs.

Mike

A transformer stage must know its metadata at compile time, so to use a transform function such as Convert() you would need to operate on a named column. You could surround the transformer stage with a pair of parameterized modify stages to rename the column of interest (the modify stage does not ne...