DSXchange

I have a .txt file that contains column definitions (metadata) for approx 100 columns (the actual data file is separate). I want to import the metadata into DS. Whats the easiest way to import it? I had a look at the schema chapter in Parallel Job dev's guide but that seems a lot of work as the form...

ray.wurlod wrote:Ah, read FROM multiple nodes.

In that case the answer to your question 2 is "yes", provided that all the nodes can see the large file.

Thanks Ray - u rock

1. No, setting stable sort alone will not cause the data to be sorted. However, this option does not become available unless you choose to sort the data (and specify sort key(s)) - it is THIS that gets the data sorted (whether a stable sort or not). 2. See answer to 1. 3. You specify this property ...

1. Maybe. It depends where the files are and how many of them there are. 2. There is no "read multiple nodes" - there is "multiple readers per node". In this case, if you specify N readers per node for one sequential file, only one node gets used, and each reader on that node re...

1. False. 2. False. 3. No. Thanks Ray - I am actually more confused now. The posts that I read earlier were opposite of this: http://www.dsxchange.com/viewtopic.php?t=104589 http://www.dsxchange.com/viewtopic.php?t=120434 Or may be I misunderstood. :? Do you mean that 1. If I specify multiple Seque...

Not correct. Stable sort means preserve the ARRIVAL ORDER OF ROWS - nothing to do with keys at all. My bad - I meant duplicate Key Values. 1. So lets say I have a dataset which is not sorted in the upstream stage and I set Stable Sort in the downstream stage - will be it sorted and the stage will t...

I am trying to read a big Flat file, that takes 20 min to open up by Notepad++. The question is related to "No. Of Nodes per Node" Vs. "Read from Multiple Nodes" properties. From posts I gathered: 1. Sequential Files can only be read sequential i.e. 1 file per node. 2. "Read...

They are not the same. Stable sort can apply even when you are not using either of the "Don't sort" options. Stable sort preserves existing order of rows when the sort keys match. This needs more memory than not doing a stable sort. Thanks Ray. So as I understand, Don't Sort means - leave...

Hi gurus I have Win XP SP2 + MS Do Net Framework 2.0 SP1 + MS Do Net Framework 3.0 SP1 + MS Do Net Framework 3.5 + VC++ 9.0 Express + Turbo C++ 4.5 and DS Enterprise 7.5x2 I installed VC++ 9.0 after DS, then removed DS, installed TC++ 4.5 as well and then reinstalled DS. Also added the PWD variable ...

I have scenario, in whic data is being load to SQL Server db using DTS from flat files generated by DS. There is a varchar field that contains quotes and DTS bombs out saying too many columns. Here is the pseudocode: If there is a single quote or double quote present then if in between characters ar...

Any idea why is this happening? -------------------- main_program: conductor node DS002 unknown via gethostbyname; h_errno = 0 main_program: Accept timed out retries = 8 main_program: The section leader on DS002 died main_program: **** Parallel startup failed **** This is usually due to a configurat...

im a bit rusty on this but believe the problem is that you are getting a Unique Constrain violation if you look at the last lin es 0025 .if &SYSUVCNT then; **** 00:38:04 UTY2402 Previous statement modified to: 0026 .if 1 then; 0027 .logoff 20; This I beleive means that it has found >0 records i...

Any point towards where to look will be also be appreciated. Pls give your suggestions.

Hi Gurus I have inheritied a few jobs that load data into the TeraData database using Multiload. One of the jobs has: .logtable #$TDWorkDB1#.NEX_LOG_INS_#TableNm1#; .logon #$TDPID#/#$TDUserId1#,PASSWORD; .set DBNAME to '#$TDDB1#'; .set TBNAME to '#TableNm1#'; .set JOBNAME to '#ThisJobNm#'; .begin im...

Post your syntax - the suggestion was strictly in regards to using one rather than a bajillion inline function calls. The syntax still contains a billion functions: Convert(Char(135),'c', <snip> :? Not if you set it up correctly. The online help shows it takes a list of characters to look for and a...