DSXchange

dspxlearn

So, for long term backup should we load them to sequential files eventually?

dspxlearn

I suggest this code:

If IsNotNull(string)
Then if Len(Trim(string)) > 0
        Then <do something>
Else <do something>

dspxlearn

Seems, your duplicate post did not work

viewtopic.php?t=127512

dspxlearn

It seems you are getting date timestamp before your string. USG123 20090403145343 NES2_Erc_VTTF2972.data USG104 20090515091147 HYD_MSS3_VTTF9741.data If this is always the same case, you could probably use something like Col1[21,Len(Field(Col1,'_',2))] Col1 --> Your source column in Varchar format

dspxlearn

By viewing the data from the sequential file are you seeing a single space or multiple spaces or nothing for that paticular record?

dspxlearn

Check this out.

viewtopic.php?t=118771&highlight=return+codes

I had bookmarked this link long time back.

Search would be helpful before posting and waiting for the reply.

dspxlearn

In fact you posted on a wrong forum!!

dspxlearn

Tools --> Dataset management --> Small window pops up --> select the dataset file which was created --> Again a small window pops up showing you the nodes name and the segments --> select each one and hit on the delete button on the top --> Its gone!! :D Single try doesn't give results most of the ...

dspxlearn

Hello, I was designing a sequencer in which a loop executes more than 280 times. Inside the loop there are couple of execute command stages executing few UNIX commands. At 258th iteration the sequencer is getting aborted with the below error. Attempting to Cleanup after ABORT raised in stage CSV_Mod...

dspxlearn

Thanks Craig!!

I must mark this thread as resolved asap.
Else, i will get 'Welcome Aboard" replies.

dspxlearn

Hi, Can we redirect the output of the execute command stage to a file inside the stage itself? Below is the inputs to the execute command stage: command: sed -n parameters: 1,10p /tmp/source.txt > testfile.txt When the job runs no file is being created. If don't send it to a file, i could see the ou...

dspxlearn

I used the string formatting instead of the conversions.
Thanks!!

dspxlearn

Hi, I need to convert the '04/01/2009' date in string format to '4/1/2009'. Basically, i need to trim out the leading zeros using Trim functions. My code: Trim('04/01/2009'[1,2], '0','L') :'-' : Trim('04/01/2009'[4,2], '0','L') :'-': Right('04/01/2009',2) Output will be 4/1/09. Instead of using this...

dspxlearn

Hello ArndW,

By an chance, did you get to hear anything from IBM guys on this Ecase?

Code: Select all

It would seem that there is ECase 118247 open on this issue and is states

dspxlearn

Hi,

I am wondering if we can capture the number of rejected records using the job log. Usually, if few records rejects the job will finish with warnings and it will show only the number of records loaded but not the number of records rejected.
Can you please let me know how this can be captured?

DSXchange

Search found 288 matches

Sequencer looping failure

redirecting the execute command output

Date format

Capture reject records from log