Search found 53125 matches

by ray.wurlod
Thu Jun 14, 2012 2:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datatype maxsize in datastage
Replies: 4
Views: 3515

Your original question specified a character string. Data type sizes are all specified precisely in Chapter 2 of the Parallel Job Developer's Guide.
by ray.wurlod
Thu Jun 14, 2012 12:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Compilation of job
Replies: 2
Views: 980

Less traffic on the network between engine and client tiers.
More powerful server for engine tier.
Fewer columns in design.
by ray.wurlod
Thu Jun 14, 2012 12:09 am
Forum: General
Topic: Get and set variables
Replies: 2
Views: 1125

You could use a User Variables activity. This is accessible anywhere downstream of itself.
by ray.wurlod
Thu Jun 14, 2012 12:05 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: How do I rename a project?
Replies: 3
Views: 3609

The project is a DataStage project, which means that it's also an account name and a schema name and probably recorded in myriad locations in XMETA and maybe even XMETASR if you're using version 8.7. Probably easiest is create a new, empty DataStage project, export everything from ANALYZERPROJECT, i...
by ray.wurlod
Wed Jun 13, 2012 6:58 pm
Forum:
Topic: What font is best for Business Glossary .csv imports?
Replies: 7
Views: 2762

But, if you can find out what they are, you can convert them.
by ray.wurlod
Wed Jun 13, 2012 6:55 pm
Forum:
Topic: How to associate a 'project' to a set of terms?
Replies: 7
Views: 2472

Another thought.

Is there a separate steward allocated to each project, and therefore to all of the terms originating from that project? If so you might use Steward as the differentiating factor.
by ray.wurlod
Wed Jun 13, 2012 6:54 pm
Forum:
Topic: How to associate a 'project' to a set of terms?
Replies: 7
Views: 2472

That's why I recommended custom attribute. Labels are pure text, nothing else. That can not, as you have determined, be allocated during import of terms, only subsequently. Custom attributes can be imported if you are using an XML import format. Both custom attributes and labels can be used to filte...
by ray.wurlod
Wed Jun 13, 2012 4:39 pm
Forum:
Topic: What font is best for Business Glossary .csv imports?
Replies: 7
Views: 2762

No it's a salvo from someone with experience and knowledge of typography. You can only experiment. The small square is not really there; it's how your viewer tool displays the character. What you need to do is to find another viewer with hex dump capability (for example UltraEdit) and figure out exa...
by ray.wurlod
Wed Jun 13, 2012 4:37 pm
Forum:
Topic: How to associate a 'project' to a set of terms?
Replies: 7
Views: 2472

I'd create a custom attribute called Project and provide it with a list of values such as HR, Finance, Healthcare.

You can filter on custom attributes when searching for terms.
by ray.wurlod
Wed Jun 13, 2012 4:35 pm
Forum: General
Topic: Need to run a Seq withinn another
Replies: 9
Views: 3303

Why not just have DataStage collect operational metadata automatically?

If you're on version 8.7 or later, you can use the Operations Console to keep a history and watch trends.
by ray.wurlod
Wed Jun 13, 2012 4:31 pm
Forum: General
Topic: Datastage Connectivity to multiple servers
Replies: 14
Views: 8171

Engine credentials are a totally separate issue. You have not configured credentials in the services tier for the DataStage engine in question, at least not for that particular user.
by ray.wurlod
Wed Jun 13, 2012 4:29 pm
Forum: General
Topic: how to callback to DS to get its Recent job ouput
Replies: 5
Views: 2239

After job subroutine would be my preferred mechanism. That way you can use DSJ.ME as the job handle. The only downside is you have to fake the "job finished" message based on DSJ.JOBINTERIMSTATUS.
by ray.wurlod
Wed Jun 13, 2012 4:26 pm
Forum:
Topic: What font is best for Business Glossary .csv imports?
Replies: 7
Views: 2762

It has nothing to do with the selected typeface. It has to do with the way that the characters are encoded, for example ASCII, UTF-8, ISO8859-1 or some other.

Pet peeve: Microsoft have foisted this improper use of "font" meaning "typeface" upon the world. Resist it.
by ray.wurlod
Wed Jun 13, 2012 12:57 am
Forum: General
Topic: How to re-run entire sequence?
Replies: 1
Views: 1514

What was the status before you ran the sequence? If it was Restartable, then any checkpointed activities will be skipped. You can reset or recompile the sequence to force all activities to be executed; this - among other things - clears the checkpoint record.
by ray.wurlod
Wed Jun 13, 2012 12:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datae cannot be in future, If future rejects
Replies: 2
Views: 883

Code: Select all

StringToDate(InLink.TheDate, "%mm/%dd/%yy") > CurrentDate()