DSXchange

The error message is required column is missing. The reason I am getting this is because I have mapped the sequential file columns with the columns in the oracle table. In the CSV file I have **DISCLOSURE** text in one of the columns at the end of file and nothing in the other columns. I want to fil...

I have a datastage job that loads a csv file into an Oracle Database. The csv file has some disclosure text at the bottom which prevents the file from being loaded. Is there a way I can filter out this unwanted text while loading the data.

Thank you

I have a column in a CSV file that holds Decimal values. However there are some rows with N/A in it. Can I use the Digit function or is there something available that would ignore NA. Thank you. I will do that. Thank you. These are primary questions and are discussed before. Try searching for them b...

I will do that. Thank you.

DSguru2B wrote:These are primary questions and are discussed before. Try searching for them before asking.

Code: Select all

dsjob -run -jobstatus -param .....
RetCd=$?

RetCd will have the jobstatus.
Really, please search before asking.

Thank you. That worked. How do I get the status of DSJob in a variable and is there a parameter that I need to pass for DSJob to return the status.

DSguru2B wrote:You need quotes. Your param should look like

Code: Select all

dsjob -run -param 'FILENAME=/path/of/3 February 2006.csv' 

I am passing the file path and file name as a parameter to the Sequential File stage using DSJob that is called from a unix script. So you have a file with the name '3 February 2006.csv' ? How are you opening this file in your script? First of all you have spaces in the name of your file, not a good...

Thank you. I get an error Status code = -9999 DSJE_DSJOB_ERROR when I am calling DSJob from a Unix script. This job only fails for the file with the name as 3 February 2006.csv. When I test the same from within Datastage it works fine. Can someone please tell me what I is incorrect out here. Look in...

I did that and when I ran it I see this error in the director

|MLConvertibleHistoryLoad..Sequential_File_23.DSLink39: DSD.SEQOpen No Filename to open..|
Thank you

DSguru2B wrote:Compile the job. DSJE_BADSTATE is indicating that the job is not in a runnable state.

I get Status code = -2 DSJE_BADSTATE when executing the DSJOB command in a Unix script. I am passing the file name to Sequential File stage in a loop. This is to merge all the files in a directory into one.

DSguru2B wrote:You gave -warn two times. Only one is needed.

I get Invalid Arguments. This is the command I am executing. eval $DATASTAGE_HOME/DSEngine/bin/dsjob -run -warn -param accountNumber=$accountNumber -param fileName=$fileName -param lookUpFile=$lookupFilePath -param outputFileName=$outputFile -warn 5 MuniStQa MLConvertibleHistoryLoad Am I missing som...

Thank you

chulett wrote:

sashah wrote:or -param name1=value1 -param name2=value2

That way.

Thank you for your reply. I am going to try this. However I had a question related to command line interface. How do you pass multiple parameters to DSJob ? Is it -param name1=value1,name2=value2 or -param name1=value1 -param name2=value2 Thank you again. I am still not clear on how to use the Filte...

I am still not clear on how to use the Filter option to process files in a directory.

chulett wrote:No, wildcards in the Filter option of the Server Sequential File stage. ...

Thank you.

DSguru2B wrote:Check the section 'Command Line Interface' in Server Job Developer's Guide.

Thank you for all your help. Can you tell me which reference manual to refer to for calling the DSJob from a Unix prompt. I found some older post in this forum regarding the same but I could not find the reference manual to refer to. I have already written a shell script that loops through files in ...