DSXchange

Thanks for the practical suggestions, Mike. The reason that I asked the question was actually that, I saw at another place a tip for identifying the column causing problem during sequential file read, is to play with the Record Options tab, eg. something like enabling the "print field" opt...

Hi,

How can I know which column is causing error during sequential file read?

thanks

Hi,

Which stages allow field names to be specified using job parameters?
Or maybe rather, which can't?

thanks

Is that happens only to a particular job or to all of the jobs? Did you try creating a new job? Is that the same? Everything, starting with new job and revert to old ones. FYI, having found the following Datastage FAQ entry, I gave up trying and restore my last-good os backup. Datastage Designer ha...

many thanks for the explanation of why those mode are chosen.

Are COBOL copybooks normally of EBCDIC characters?

thanks

I need to convert the following PLSQL code into DS stages: I have a bunch of following insert statements appending to the same table: INSERT INTO summary ( f1 , f2 ) SELECT f_fixed , f_var FROM tbl1 a , tbl2 b WHERE a.pk1 = b.pk1 AND a.pk2 = b.pk2 GROUP BY f_fixed , f_var; whereas each insert statem...

Hi, I heard the saying that - source data from mainframe dataset should be ftped using the binary mode, whereas - COBOL copybook files should be ftped using th text mode I'm wondering if the above absolutely necessary? what'd happen otherwise. what's the general guild-line choosing the ftp mode. tha...

Hi, DataStage Jobs are generally exported and imported using the DataStage Manager GUI tool. However, I'm more interested in doing export/import at the Command line. DSEXPORT/DSIMPORT command will work only for individual jobs. DSCMNDEXPORT command provide options to export whole project in DSX form...

Could you elaborate a bit more, Ray, please?

I guess the principle to define columns, data types, and other format options in the *parallel* Column Import stage, not the Sequential stage still hold, just the practice how to add the surrogate key has changed, right?

thanks

. . . if your intent is to just parse it back out with Column Import, don't even bother with the concatenation. Just let the surrogate key column pass through to the output of Column Import.... Thanks for the reply, Actually that's the first method that I tried, however, due to my limited knowledge...

ray.wurlod wrote: The easiest way is to choose Print from the Project menu in Director. Within the Print dialog you will find ...

That's the only thing I can see, but I'll mark it as solved anyway.

I want to define columns, data types, and other format options in the *parallel* Column Import stage, not the Sequential stage, which can improve performance because it separates parsing process from sequential read process. However, I need to assign a row number in parallel using the Surrogate Key...

chulett wrote:

Code: Select all

part1 : (if condition then exp1 else exp2) : part3 

...

That's the exact answer that I was expecting for.

Thanks a lot chulett

Hi, Does DS has the iif or the ? : operator in C? E.g., I want to build up an output string part1 : part2 : part3 where part1 & part3 are substring of the input string, and part2 need to be conditionally build according to some specific key char in the input string. The "part2" express...

Hi, Another noob question, In trasnformer, I have such derived variable defined, IF IsNotNull(the_field) THEN 'Y' ELSE 'N' -- IsFound Then the variable IsFound is used as an output constrain, e.g, if IsFound = 'Y' Coming from C/C++ background, I'm wondering if I can just use IsNotNull's Return as-is...