DSXchange

It was because the first day of the year is a tuesday that's right!

Thanks for your precious help.

I'm facing an issue using the yearweekfromdate function in a PX transformer. My job uses a row generator in input to generate incremental dates. I want to catch the week number for each date but it seems that this function returns tuesday as the first day of the week (monday is day 0 and tuesday is ...

I'm currently encountering an issue while trying to convert datas fro my input flat file. My input flat file is defined with one column in varchar format. I'm using a transformer to convert a part of each input rows to decimal value using StringToDecimal function and with an output type set to decim...

Hi, I have a restartable job sequence that is launched by an unix shell with the dsjob command. My problem is when I stop the job, so it's status become 'Stopped/Restartable', it doesn't start when I launch the shell one more time since I reset it. My command is : dsjob -run -NORMAL. So is there any...

I found the issue, I have just set the jobs' names to '#JobName#':'.':'#FileName#' in the job control.
It works fine.

Thanks for your response but can you tell me how to do that thing please?
What is the function to use to pass this parameter to parallel jobs, DSSetParam?

Hi,
I have some five template jobs, with multiple instance option allowed, to run with several files and I want to run them in parallel.
They're launched by a job control.
Does anybody knows if it's possible to give a dynamic invocation Id called by the job control and how?
Thanks in advance.

chulett wrote:Did you read the post I linked to? Did you try everything noted there, including setting APT_IMPORT_PATTERN_USES_FILESET to TRUE? ...

You're right, it works fine!!!!

Thank you very much.

I tried to use File Name Column option in the sequential stage with a Read Method set to File Pattern and using a wildcard for my filename as FILENAME* (where my real file name is still FILENAME_YYYYMMDD). Then I get this result in the output column "FILENAME*". I wonder why it returns me ...

Hi,
I have a sequential file in source, which name is like FILENAME_YYYYMMDD.
I want to get the "YYYYMMDD" part of the filename in order to load it in a table.
Do you have any idea please?

Thanks in advance.

DSguru2B wrote:Seqential file stage's properties, go to options, you will see an option "First Line Is Column Name". Set that to True or False accordingly. ...

Thank you for your response but I want to do specify that only in the schema file and not in the sequential file stage.

Thanks

Hi,
I would like to know if it's possible to specify in the schema file that the first line of a sequential file is the column name and how to do that.

Thanks in advance.

Thank you for your help, it works!

Hi, I would like to specify a partial name for a seq file in the seq file stage because the name of my file is FILENAME_YYYYMMDD (where YYYYMMDD is the creation date of the file). I tried to specify FILENAME* in the seq file stage but it didn't work. On DS Server, I would have use the folder stage b...

Sorry this is a bit confusing. You say that there is one record but 2 lines. But any ways please tell us how you have defined the metadata? The definition of schema file is : -schema record {final_delim=end, record_delim_string='\r\n', delim='\n', quote=none, ascii, text, fix_zero} ( DATE_FIC:strin...