DSXchange

You probably need "hard quotes" (single quotes).
You don't need to cd.

Who knows? It's certainly a possibility. Try using the URL path rather than the file.

My previous post talked about row size, not about total volume.

We don't do URGENT here. DSXchange is an all-volunteer site whose participants post as and when they can. If you want urgent help, sign up with your support provider for premium service, and learn how much "urgent" is worth. Further, URGENT is not a particularly meaningful subject. You should alway...

Welcome aboard. Your term "filevalidation" is too vague. You need to specify exactly what you require to do, and then we can perhaps suggest some techniques to accomplish the same. You might also think about providing a definition of "real time". It is physically impossible to process 2GB of data in...

A job can remove the messages from the queue and write them to /dev/null in a Sequential File stage. This is fairly fast. (On Windows use .\NUL instead of /dev/null.)

As we know for each .ds descriptor file we only have one dataset file in each node, even though we have run job with multi-instance in sequence. We know no such thing. It is definitely possible to have more than one segment file per partition, especially if you append to a Data Set, or if there is ...

None of which negates anything I posted. It appears that other circumstances - as well as reference links - can generate this warning. It's still just an alert that something unusual, or non-standard, exists in the design.

A DataStage repository in the version you indicated (7.x) is a schema in a database. It contains a number of tables. As a generic inquiry, ignoring DataStage, how would you (ramesh_inform) go about tuning a database schema? Most of the same principles apply to the DataStage repository but, being an ...

OK, sounds like that's something to work on. You need to discover why it's not being passed. Are you using the environment variable as a job parameter? If so, how are you referring to this when generating the script command?

Unfortunately for Thirunavukkarasu's idea, the Field() function only uses a single-character delimiter - if more than one is supplied then only the first character in the string is used. So it wouldn't work for LEONARD COHEN DBA BIRD ON THE WIRE Try sv0 --> Index(InLink.TheString, "DBA"...

And "DWB" gives the abbreviated form, for example "FRI".

Modulus is more efficient than Hash because it does less work. Do an all terms search for both terms; I've explained it elsewhere. Modulus algorithm does guarantee key adjacency on each partition.

If you must use parallel expressions in Transformer stage, use Index() to determine where "DBA" occurs, and substrings (possibly with Trim()) to extract what's either side of that. Putting the Index() function in a stage variable is best, because you need that result more than once, but don't need t...

What exactly is the problem? Are the data modifications occurring? The message is informing you that the driver is electing to manage commits differently than how you have specified in your stage. So what, if it works? Why are you using ODBC, probably the slowest interface to DB2? Best choice is DB2...