Search found 53125 matches

by ray.wurlod
Fri Jun 29, 2012 5:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can't compile tranformer stage in parallel job
Replies: 5
Views: 1799

What about the four APT_ environment variables mentioned in my earlier post?
by ray.wurlod
Fri Jun 29, 2012 5:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Could not locate operator definition, wrapper
Replies: 12
Views: 4928

Did you import a job containing a SQL Server stage from a Windows machine to your UNIX machine?
by ray.wurlod
Fri Jun 29, 2012 5:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fixed width
Replies: 8
Views: 2564

Code - rather than Quote - preserves formatting.
by ray.wurlod
Fri Jun 29, 2012 5:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Seeking a best solution in DataStage
Replies: 28
Views: 22304

A Roman with a bad stammer trying to say 95? :lol:
by ray.wurlod
Fri Jun 29, 2012 5:46 am
Forum: General
Topic: Verson control (SVN?), Eclipse and Datastage 8.5
Replies: 1
Views: 1982

DataStage jobs are exported and otherwise managed using Information Server Manager. It is within that client that you can use the Eclipse plug-in to interface with SubVersion (in the Team menu).
by ray.wurlod
Fri Jun 29, 2012 5:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Parsing Source File
Replies: 6
Views: 2864

... except that there's no Funnel stage in server jobs. Though a hashed file can be employed to the same end, though needing a generated key.
by ray.wurlod
Fri Jun 29, 2012 5:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CFF Stage issues
Replies: 5
Views: 2054

I disagree, as I explained above.
by ray.wurlod
Fri Jun 29, 2012 5:41 am
Forum: IBM QualityStage
Topic: Using a wildcard override for name standardization
Replies: 5
Views: 3213

Alas no. The universal class is not available for overrides. You might try classifying * as class I (initial) using a Classification override, to see whether that would meet your needs.
by ray.wurlod
Thu Jun 28, 2012 8:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning
Replies: 6
Views: 5358

Read the error messages carefully. Already there you can see that you have bad data. We don't need to see any more of it. Only you can resolve this, by ensuring that the data are clean. Perhaps you can read this field as a VarChar rather than as a Date, and then validate and convert downstream of th...
by ray.wurlod
Thu Jun 28, 2012 4:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Find Message Handlers defined
Replies: 6
Views: 3730

Actually it's THE project level default message handler - there can only be one of these. But there can be other named message handlers extant that are attached to zero or more jobs.
by ray.wurlod
Thu Jun 28, 2012 4:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can't compile tranformer stage in parallel job
Replies: 5
Views: 1799

Have you correctly set all the environment variables at the operating system level (PATH, LIBPATH, INCLUDE) and within DataStage (APT_COMPILER, APT_COMPILE_OPTIONS, APT_LINKER, APT_LINKER_OPTIONS) ?
by ray.wurlod
Thu Jun 28, 2012 4:43 pm
Forum: General
Topic: Passing Dynamic values as Parameters
Replies: 2
Views: 1339

Welcome aboard. That's exactly what parameters do. When you submit a job run request you are prompted for the parameter values (or you use -param option in the dsjob command line). If you need to detect the file name, you use a sequence with a command to retrieve the file name (for example ls -lrt F...
by ray.wurlod
Thu Jun 28, 2012 4:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CFF Stage issues
Replies: 5
Views: 2054

You could read the entire line as a single string using Sequential File stage, and insert CRLF strings where you want them (and maybe commas) before writing back to a file. Then read from that file. For example, if you have PIC XX OCCURS 30 you can read a 60 character string. Use Fmt() or Fold() fun...
by ray.wurlod
Thu Jun 28, 2012 4:35 pm
Forum: General
Topic: calling parameters from file
Replies: 5
Views: 2459

You specified parallel job type. Therefore you have MKS Toolkit. Therefore you can use UNIX commands.
by ray.wurlod
Thu Jun 28, 2012 4:33 pm
Forum:
Topic: Importing Erwin models into Metadata Workbench
Replies: 4
Views: 3573

Is the ERwin model saved in CA Fusion Repository format into an XML file? This is the only format that the "ERwin 7 (File)" bridge can handle.