DSXchange

Hi,
What did you supply in the Stage properties regarding telnet prompts and responses?

IHTH,

Hi,
Can you give a bit more specific info?

(are you getting errors?, can you write a simple ascii file there?,...)

How about a truncate table? (will you not get permitions?)

as prefered method is to use the command line bulk loader with some DBA work you may get it done there or in a different job as you performed the delete

Hi, Error code implies : a file with none standard NLS exists which does not match your defined NLS. if you never got any file processed yet try to get the list of files as it would arrive to the folder stage and check the first file for having unusuall/unsupported NLS characters (unsupported by you...

Hi,
recently there was another post which also addressed the difference in maintaining and migrating those project variables between projects.

another thing effecting your decision.

Hi,
Beside agreeing with Ray on Bulk loads,
Have you encreased the packets size? (512 multiples)

IHTH,

Hi, If you want to create cotrol files containing number of rows and such in ds server your most simple solution would be: 1. add a hash file with dummy key column having 1 as it's value. 2. split the output in a transformer to add the hash file with fixed 1 in the key column and the @OUTROWNUM or @...

Hi,
A site being here or Ascential.com in the Ascential Developer's Network.
you can search this forum for similar posts.
by the way what do you mean by

shell scripts which can be used in DataStage

?

you can run any script/OS command line from DataStage.

IHTH,

rofmlao , got cought in my peer's demise! my peers call a sequence job sequencer, tough I try correcting them, I guess they corrupted me my post was refering to the sequence job not sequencer stage, Thank Ray for correcting this mitake you can also think of it as a syncronizing point in your sequenc...

Hi, hmmm, assuming you have no DS training. did not try searching this forum. are you RFIing (Requesting For Information) or got the product and was dropped in the cold waters with no clue? in short it is a GUI design of a sequence of events/activities that serves as a wrapper for a logical process ...

Hi, The one part that does look stange and problematic is if I select the SQL tab then the following code appears :- INSERT INTO spectrum.dbo.t_ptfo_extract_time_perd (series_id,str_typ_1,ptfo_cd) VALUES (?,?,?); this insert looks fine the question marks are place holders for run time values of the ...

Hi,
doesn't anybody use the cleaup resources via director and DS.TOOLS anymore?

ArndW, I just feel in some posts that the poster would benefit more if they state the whole scenrio instead of giving a 1 or 2 liner post. we all seen it before when the xth reply nailed the answer simply since not enough info was specified in the original post and the actuall answer was in a new di...

Hi,
to dump a DataSet file to the standard output:


you could invoke orchadmin from command line to get all options
or search in the docs.

IHTH,

Hi, naturally you must also concider the machine load at the time you want to run the job. bare in mind 1 process for the link partitioner and 1 for the collector making 2, plus depending on your design x processes where x stands for the number of links you split it to; making a minimum total of 2 +...