Search found 53125 matches

by ray.wurlod
Mon Dec 05, 2011 3:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: converting varchar to Date and validation
Replies: 1
Views: 934

IsValid() tests the string. Don't apply StringToDate() first. What you really want is something like

Code: Select all

If IsValid(InLink.TheString, "date") Then StringToDate(InLink.TheString) Else SetNull()
by ray.wurlod
Mon Dec 05, 2011 3:10 pm
Forum: General
Topic: To add a function to the parameter value ?
Replies: 12
Views: 3889

Oconv() can accept a multi-valued list of conversions, which are applied one after another.
"D4YMD" generates "2011 12 06".
"MCN" applied to that removes the non-numeric characters, yielding "20111206".
by ray.wurlod
Mon Dec 05, 2011 3:09 pm
Forum: General
Topic: Export from command line
Replies: 5
Views: 2191

Try the /O (omit) switch.
by ray.wurlod
Mon Dec 05, 2011 3:08 pm
Forum:
Topic: Unwanted jobs in Production Environme for Automation binding
Replies: 2
Views: 1789

I don't believe so. Automated services is "all or nothing".
by ray.wurlod
Mon Dec 05, 2011 3:07 pm
Forum:
Topic: Date formate
Replies: 1
Views: 1087

Please post in the correct forum (server jobs or parallel jobs). This is not a question about metadata or Metadata Workbench.
by ray.wurlod
Mon Dec 05, 2011 3:02 pm
Forum: IBM QualityStage
Topic: Match DataBase
Replies: 3
Views: 1296

The Match Designer database is not used at all in jobs; it is only used by the Match Designer client. Tables in the Match Designer database are created automatically when you test a match specification. While you could certainly configure other clients to look at the Match Designer database, you wou...
by ray.wurlod
Mon Dec 05, 2011 2:49 am
Forum: General
Topic: Unpacking Downloaded Software
Replies: 2
Views: 1176

I don't believe you even need those - everything (all four tiers) are in the 4GB main download of Information Server. I suspect that you need them only for the occasions you need to install WebSphere Application Server separately.
by ray.wurlod
Mon Dec 05, 2011 2:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Looping
Replies: 5
Views: 1613

Yes it is. Basically you have to maintain counts (probably in stage variables) then, when the counts are reached, output your FormFeed character (or however else you are effecting a page break) and resetting the counter before proceeding with more rows. Similarly use stage variables (or an upstream ...
by ray.wurlod
Sun Dec 04, 2011 11:28 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: DS jobs to be parameterized while exposed as webservi
Replies: 2
Views: 3168

Parameter values are resolved when the job is started. Therefore, as you surmise, they can not legally be changed once an always-running job is running. You need to get them right when the job is started. It is also possible through ISD to create "on demand" jobs for infrequent access. The...
by ray.wurlod
Sun Dec 04, 2011 10:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to search a particular record/row in a Dataset
Replies: 3
Views: 1779

A Data Set can be viewed outside of DataStage, using the orchadmin command (search DSXchange or the manuals for more information). However there is no scope for selection; you can only read all rows (then, possibly, pass them through a filter of your choice).
by ray.wurlod
Sun Dec 04, 2011 9:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential File Stage -- Flat file data load
Replies: 4
Views: 3066

Use Char(21) for the data type rather than VarChar(21). This should cause the reject behaviour you require. You could pass the reject link into a Column Import stage that re-parses the line as two Char(21) columns.
by ray.wurlod
Sun Dec 04, 2011 4:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to open sequential file
Replies: 2
Views: 1770

You may lack write privilege for the "target" directory if "test.csv" does not exist, or to "test.csv" if it does exist.
by ray.wurlod
Sun Dec 04, 2011 12:04 pm
Forum: General
Topic: Unusual dssh/uvsh responses
Replies: 5
Views: 1335

2. would come from the command LOGTO Checking.

3. would ordinarily come from a TERM or SET.TERM.TYPE command, which you would rarely use with DataStage.

No idea at the moment about RING. "Unidentified token" is a general parser error.
by ray.wurlod
Sun Dec 04, 2011 12:01 pm
Forum: General
Topic: To add a function to the parameter value ?
Replies: 12
Views: 3889

The conversion specification for Oconv() needs to be upper case - you may wish to get rid of the space delimiters that this gives by default.

Code: Select all

Name : Oconv(Date(), "D4YMD" : @VM : "MCN")
by ray.wurlod
Sat Dec 03, 2011 3:49 pm
Forum: General
Topic: To add a function to the parameter value ?
Replies: 12
Views: 3889

What is the exact expression you used in the job parameter reference in the sequence Job activity?