DSXchange

I agree with Craig - even though DS can process files and file lists, all you need to do is a "type c:\mydir\*.txt >> outfile.txt" in dos and skip the lines that contain empty or just the filename. Or get the free unix commands for dos and use the cat command.

anupam,

have you use a BASIC transformer stage and not a normal transformer stage in the Px job?

Kumar,

there is no limit that I can think of regarding number of jobs from the engine itself - perhaps some of the tools on the client side have fixed widths that might cause a problem, but I am sure that 1000 should not cause us an issue. 500 in your case should be a breeze

anupam, if performance is not an issue, you can always use a BASIC transform stage in a parallel job and enjoy all the benefits of the ICONV/OCONV functions for date conversions. You can use the builtin date conversions in Px such as DateToString to perform your cast to the new data column. Another ...

The problem that you can get is the performance of the Director once you have lots of jobs in a project. Breaking them up into categories helps, but sometimes the refresh rate in the director is abyssmally slow. I think we currently have several hundred jobs in one project here... let me check... 97...

Inquisitive, no, there is not. I just wrote some code to do this for a machine and it ended up being a bit complex - enough work invested into it so that I am loathe to post it in the public domain. I used the UNIX file command and created my own magic file to identify dataset and lookup file set he...

Do you have aggregations in the job? Lookups on Hash or Tables? Please just try copying your job, reading from your hash file through a transformer and writing to a sequential file. In the Transform make a constraint read "1=2" to force that no records get written to the sequential file. Then run th...

The FILLER would add white space to the end if you added a REDEFINES, since you removed a redefines you have actually already increased your record length plus shifted all of your data after the redefines location over. What you need to do in order to keep consistency is to remove the original group...

So, the T erminal C ontrol L anguage is the base level of the database environment that underlies DataStage Server. There are some commands that you might have occasion to use from DataStage jobs or from the Administrator that need to access this level; often the cleanup commands such as DS.TOOLS ar...

kumar,

you commented out a "REDEFINES" clause; are you aware that you have just changed the actual record length? The REDEFINES tells cobol that the following group occupies the same physical location as the element it is redefining, it just uses a different mask to access that data.

Ray, coming from the UniVerse side of the world, I hated having to learn all about those weird PROCs and still avoid 'em, but they do have some incredibly powerful features if you know how to program them; certainly beats the old PAragraphs. I have trouble enough with inverse Polish and never got th...

Craig,

thanks! I knew I was wrong, but didn't realize how wrong. I'm pretty good with stuff like BASIC,COBOL,SPOOL,RPG,FTN and the like and I can hold my own with ASCII,EBCDIC,ANSII but you got me here.

btw, what are you doing at the screen at this ungodly hour of your night?

A quick cut and paste of your statement shows it has 48 commas, so that would mean that you ought to have 24 column; but only 15 of those are in your value fields. So it would seem your columns and placeholds don't add up to the same number, which is also what the error message states.

Hmmm... it does sound like DS is using a different locking mechanism than I expected. What is your RLTABSZ uvconfig value? Have you submitted this to Ascential support - this might be a bug or restriction that others haven't hit {yet}.

For me the TCL has always denoted "The Command Line" but I am sure that the "T" letter has some more official meaning. The Pick type database systems (of which UniVerse and DataStage are examples) were, at one time, the actual operating system and the ">" prompt was effectively the OS prompt or the ...