DSXchange

Hi, I am running my sequence job and I am using a Loop. Within this Loop is a parallel job and then another sequence job. I am returning an error code of "code=-4 [ParamValue/Limitvalue is not appropriate]". I have re-compiled it, added "Ereplace(EC_MAX_ETN.$CommandOutput,@FM,'' )&quo...

I have found the answer to my problem. I put the file name in the parameter of the execute command stage

another question i have is how can I run multiple files in the command execute stage in a sequence job... I am using "/disk1/data/Projects/EP1978/DEV/input/copy1*.txt" for the parallel jobs. How can I mimic this in sequence?

$APT_MAX_DELIMITER_READ_SIZE (changed default value to 1000000000)
$APT_CONFIG_FILE (changed to a 1 node)

The error messages are too far back to look at, for we ran the job multiple times after we "fixed" it

I changed the job to run on 1 node because I have a smaller amount of data per incoming file. Then I used an environment variable to increase character length for record delimiter to 100000000. This works for now but I need a better way to do it for when there are millions of clients per file. The j...

Hi, I created a job where I am using * to input multiple files. I created 6 text files for the input, and each file has 2 providers. For some reason, the output dataset is splitting the output right down the middle. Each file has 44 rows, times 6, is 264. I input a sequence number (1-22) for each pr...

I currently created a job that creates a number for every entry into a table. The number will start at 5000 and will increment per provider. So if a file has 10 providers, it will be 5000-5009. If I run this same file again (or if there is a new file) I want it to start at 5010. How do I go about th...

Actually Craig, I figured it out. I inserted a new column "NUM" and then used the Row Number Column and used that in the transformer and it worked.

So an example of the TABLENAME and CLOB columns : HEADER PROVIDER20151223 The HEADER is the first row to populate in the file no matter what. We have a UNIX script that will be reading the file before it enters the job (which I took care of in the sequence job). There are errors that the UNIX looks ...

Company still is a month or so away from securing a membership. That being said, I have the text file that contains "X" amount of rows, 2 columns. The first and last row are simply HEADER and TRAILER and they are the ones that I am focused on in this certain pic. The transformer is separat...

The copy stage will spit out the answer I need just fine. But something may be wrong with the merge itself.

Hi, I have a transformer in which I branch off two links. The first link is separating the text file so that the transformer is looking at the header of a file; it gets forwarded to a merge. The second link is looking at the trailer of the file. In the trailer, I need the first 11 characters of the ...

I also took out the '%' in front and back of the quotes....

StringToTimestamp(0001-01-01 00:00:00,["%yyyy-%mm-%dd %hh:%nn:%ss"])

StringToTimestamp(0001-01-01 00:00:00,[%"%yyyy-%mm-%dd %hh:%nn:%ss"%])

I input this and it isn't working.

Hi,

I am trying to default a column, with a Timestamp datatype, to '0001-01-01'. Is there a function that will do that? I typed in the 0001-01-01 and all that was returned were stars because I did not have a function. Any help would be great. Thanks!